home *** CD-ROM | disk | FTP | other *** search
/ Shareware Super Platinum 8 / Shareware Super Platinum 8.iso / mac / DATABASE / SAC271.ZIP;1 / FOXPRO.ZIP / Q_HELP.FPT < prev    next >
FoxPro Memo File  |  1992-01-13  |  63.5 KB

open in: MacOS 8.1     |     Win98     |     DOS

view JSON data     |     view as text

This file was processed as: FoxPro Memo File (other/foxProMemo).
This format is not currently supported by dexvert.

ConfidenceProgramDetectionMatch TypeSupport
1% dexvert FoxPro Memo File (other/foxProMemo) magic Unsupported
100% file Adobe Photoshop Color swatch, version 0, 1017 colors; 1st RGB space (0), w 0x40, x 0, y 0, z 0 ; 2nd RGB space (0), w 0, x 0, y 0, z 0 default (weak)
99% file FoxPro FPT, blocks size 64, next free block index 1017, field type 1, field length 310, 1st item "This is a custom expression builder." default
98% file data default
55% TrID Matlab Level 4 MAT-File (big-endian) default (weak)
26% TrID Sybase iAnywhere memo files default
18% TrID MacBinary 1 default (weak)
100% siegfried x-fmt/342 Microsoft FoxPro Memo default (weak)
100% xdgMime image/x-tga default



hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 00 03 f9 00 00 00 40 | 00 00 00 00 00 00 00 00 |.......@|........|
|00000010| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000040| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000060| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000070| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000080| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000090| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000100| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000110| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000120| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000130| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000140| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000150| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000160| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000170| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000180| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000190| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000200| 00 00 00 01 00 00 01 36 | 54 68 69 73 20 69 73 20 |.......6|This is |
|00000210| 61 20 63 75 73 74 6f 6d | 20 65 78 70 72 65 73 73 |a custom| express|
|00000220| 69 6f 6e 20 62 75 69 6c | 64 65 72 2e 0d 0a 0d 0a |ion buil|der.....|
|00000230| 41 6e 20 65 78 70 72 65 | 73 73 69 6f 6e 20 69 73 |An expre|ssion is|
|00000240| 20 6f 6e 65 20 6f 72 20 | 6d 6f 72 65 20 73 65 6c | one or |more sel|
|00000250| 65 63 74 69 6f 6e 20 63 | 72 69 74 65 72 69 61 20 |ection c|riteria |
|00000260| 63 6f 6d 62 69 6e 65 64 | 2e 0d 0a 0d 0a 45 61 63 |combined|.....Eac|
|00000270| 68 20 73 65 6c 65 63 74 | 69 6f 6e 20 63 72 69 74 |h select|ion crit|
|00000280| 65 72 69 6f 6e 20 77 69 | 6c 6c 20 62 65 20 63 61 |erion wi|ll be ca|
|00000290| 6c 6c 65 64 20 61 20 70 | 68 72 61 73 65 2e 0d 0a |lled a p|hrase...|
|000002a0| 0d 0a 41 20 70 68 72 61 | 73 65 20 69 73 20 6d 61 |..A phra|se is ma|
|000002b0| 64 65 20 75 70 20 6f 66 | 20 74 68 65 20 66 6f 6c |de up of| the fol|
|000002c0| 6c 6f 77 69 6e 67 3a 0d | 0a 09 31 2e 20 46 49 45 |lowing:.|..1. FIE|
|000002d0| 4c 44 5f 4e 41 4d 45 20 | 20 73 75 63 68 20 61 73 |LD_NAME | such as|
|000002e0| 20 22 4e 41 4d 45 22 20 | 20 20 20 20 20 20 20 0d | "NAME" | .|
|000002f0| 0a 09 32 2e 20 4f 50 45 | 52 41 54 4f 52 20 20 20 |..2. OPE|RATOR |
|00000300| 20 73 75 63 68 20 61 73 | 20 22 62 65 67 69 6e 73 | such as| "begins|
|00000310| 20 77 69 74 68 22 20 20 | 0d 0a 09 33 2e 20 44 41 | with" |...3. DA|
|00000320| 54 41 20 20 20 20 20 20 | 20 20 73 75 63 68 20 61 |TA | such a|
|00000330| 73 20 22 53 6d 69 74 68 | 22 20 20 0d 0a 09 20 70 |s "Smith|" ... p|
|00000340| 00 00 00 01 00 00 01 98 | 54 68 69 73 20 69 73 20 |........|This is |
|00000350| 61 20 63 75 73 74 6f 6d | 20 65 78 70 72 65 73 73 |a custom| express|
|00000360| 69 6f 6e 20 62 75 69 6c | 64 65 72 2e 0d 0a 0d 0a |ion buil|der.....|
|00000370| 41 6e 20 65 78 70 72 65 | 73 73 69 6f 6e 20 69 73 |An expre|ssion is|
|00000380| 20 6f 6e 65 20 6f 72 20 | 6d 6f 72 65 20 73 65 6c | one or |more sel|
|00000390| 65 63 74 69 6f 6e 20 63 | 72 69 74 65 72 69 61 20 |ection c|riteria |
|000003a0| 63 6f 6d 62 69 6e 65 64 | 2e 0d 0a 0d 0a 45 61 63 |combined|.....Eac|
|000003b0| 68 20 73 65 6c 65 63 74 | 69 6f 6e 20 63 72 69 74 |h select|ion crit|
|000003c0| 65 72 69 6f 6e 20 77 69 | 6c 6c 20 62 65 20 63 61 |erion wi|ll be ca|
|000003d0| 6c 6c 65 64 20 61 20 70 | 68 72 61 73 65 2e 0d 0a |lled a p|hrase...|
|000003e0| 0d 0a 41 20 70 68 72 61 | 73 65 20 69 73 20 6d 61 |..A phra|se is ma|
|000003f0| 64 65 20 75 70 20 6f 66 | 20 74 68 65 20 66 6f 6c |de up of| the fol|
|00000400| 6c 6f 77 69 6e 67 3a 0d | 0a 09 31 2e 20 46 49 45 |lowing:.|..1. FIE|
|00000410| 4c 44 5f 4e 41 4d 45 20 | 20 73 75 63 68 20 61 73 |LD_NAME | such as|
|00000420| 20 22 4c 41 53 54 5f 4e | 41 4d 45 22 20 20 20 20 | "LAST_N|AME" |
|00000430| 20 20 20 20 0d 0a 09 32 | 2e 20 4f 50 45 52 41 54 | ...2|. OPERAT|
|00000440| 4f 52 20 20 20 20 73 75 | 63 68 20 61 73 20 22 62 |OR su|ch as "b|
|00000450| 65 67 69 6e 73 20 77 69 | 74 68 22 20 20 0d 0a 09 |egins wi|th" ...|
|00000460| 33 2e 20 44 41 54 41 20 | 20 20 20 20 20 20 20 73 |3. DATA | s|
|00000470| 75 63 68 20 61 73 20 22 | 53 6d 69 74 68 22 20 20 |uch as "|Smith" |
|00000480| 0d 0a 09 0d 0a 09 45 78 | 61 6d 70 6c 65 3a 20 20 |......Ex|ample: |
|00000490| 46 49 45 4c 44 5f 4e 41 | 4d 45 20 20 20 4f 50 45 |FIELD_NA|ME OPE|
|000004a0| 52 41 54 4f 52 20 20 20 | 20 44 41 54 41 0d 0a 09 |RATOR | DATA...|
|000004b0| 20 20 20 20 20 20 20 20 | 20 20 4c 41 53 54 5f 4e | | LAST_N|
|000004c0| 41 4d 45 20 20 20 20 62 | 65 67 69 6e 73 20 77 69 |AME b|egins wi|
|000004d0| 74 68 20 22 53 6d 69 74 | 68 22 0d 0a 09 09 20 20 |th "Smit|h".... |
|000004e0| 4a 3b 54 06 74 1e 83 7c | 06 00 7c 08 8b 54 06 31 |J;T.t..||..|..T.1|
|000004f0| db e8 c6 f3 49 89 4c 06 | 7c 0a 89 ca 89 f0 bb 01 |....I.L.||.......|
|00000500| 00 00 00 01 00 00 02 45 | 54 68 69 73 20 69 73 20 |.......E|This is |
|00000510| 61 20 63 75 73 74 6f 6d | 20 65 78 70 72 65 73 73 |a custom| express|
|00000520| 69 6f 6e 20 62 75 69 6c | 64 65 72 2e 0d 0a 0d 0a |ion buil|der.....|
|00000530| 41 6e 20 65 78 70 72 65 | 73 73 69 6f 6e 20 69 73 |An expre|ssion is|
|00000540| 20 6f 6e 65 20 6f 72 20 | 6d 6f 72 65 20 73 65 6c | one or |more sel|
|00000550| 65 63 74 69 6f 6e 20 63 | 72 69 74 65 72 69 61 20 |ection c|riteria |
|00000560| 63 6f 6d 62 69 6e 65 64 | 2e 0d 0a 0d 0a 45 61 63 |combined|.....Eac|
|00000570| 68 20 73 65 6c 65 63 74 | 69 6f 6e 20 63 72 69 74 |h select|ion crit|
|00000580| 65 72 69 6f 6e 20 77 69 | 6c 6c 20 62 65 20 63 61 |erion wi|ll be ca|
|00000590| 6c 6c 65 64 20 61 20 70 | 68 72 61 73 65 2e 0d 0a |lled a p|hrase...|
|000005a0| 0d 0a 41 20 70 68 72 61 | 73 65 20 69 73 20 6d 61 |..A phra|se is ma|
|000005b0| 64 65 20 75 70 20 6f 66 | 20 74 68 65 20 66 6f 6c |de up of| the fol|
|000005c0| 6c 6f 77 69 6e 67 3a 0d | 0a 09 31 2e 20 46 49 45 |lowing:.|..1. FIE|
|000005d0| 4c 44 5f 4e 41 4d 45 20 | 20 73 75 63 68 20 61 73 |LD_NAME | such as|
|000005e0| 20 22 4c 41 53 54 5f 4e | 41 4d 45 22 20 20 20 20 | "LAST_N|AME" |
|000005f0| 20 20 20 20 0d 0a 09 32 | 2e 20 4f 50 45 52 41 54 | ...2|. OPERAT|
|00000600| 4f 52 20 20 20 20 73 75 | 63 68 20 61 73 20 22 62 |OR su|ch as "b|
|00000610| 65 67 69 6e 73 20 77 69 | 74 68 22 20 20 0d 0a 09 |egins wi|th" ...|
|00000620| 33 2e 20 44 41 54 41 20 | 20 20 20 20 20 20 20 73 |3. DATA | s|
|00000630| 75 63 68 20 61 73 20 22 | 53 6d 69 74 68 22 20 20 |uch as "|Smith" |
|00000640| 0d 0a 09 0d 0a 09 45 78 | 61 6d 70 6c 65 3a 20 20 |......Ex|ample: |
|00000650| 46 49 45 4c 44 5f 4e 41 | 4d 45 20 20 20 4f 50 45 |FIELD_NA|ME OPE|
|00000660| 52 41 54 4f 52 20 20 20 | 20 44 41 54 41 0d 0a 09 |RATOR | DATA...|
|00000670| 20 20 20 20 20 20 20 20 | 20 20 4c 41 53 54 5f 4e | | LAST_N|
|00000680| 41 4d 45 20 20 20 20 62 | 65 67 69 6e 73 20 77 69 |AME b|egins wi|
|00000690| 74 68 20 22 53 6d 69 74 | 68 22 0d 0a 0d 0a 41 6e |th "Smit|h"....An|
|000006a0| 20 65 78 70 72 65 73 73 | 69 6f 6e 20 6d 61 79 20 | express|ion may |
|000006b0| 68 61 76 65 20 6d 6f 72 | 65 20 74 68 61 6e 20 6f |have mor|e than o|
|000006c0| 6e 65 20 70 68 72 61 73 | 65 2e 20 54 68 69 73 20 |ne phras|e. This |
|000006d0| 61 6c 6c 6f 77 73 20 79 | 6f 75 20 74 6f 20 63 72 |allows y|ou to cr|
|000006e0| 65 61 74 65 0d 0a 73 6f | 6d 65 20 76 65 72 79 20 |eate..so|me very |
|000006f0| 73 6f 70 68 69 73 74 69 | 63 61 74 65 64 20 73 65 |sophisti|cated se|
|00000700| 6c 65 63 74 69 6f 6e 20 | 63 72 69 74 65 72 69 61 |lection |criteria|
|00000710| 2e 0d 0a 0d 0a 50 68 72 | 61 73 65 73 20 61 72 65 |.....Phr|ases are|
|00000720| 20 63 6f 6d 62 69 6e 65 | 64 20 77 69 74 68 20 74 | combine|d with t|
|00000730| 68 65 20 66 6f 6c 6c 6f | 77 69 6e 67 20 43 4f 4e |he follo|wing CON|
|00000740| 4e 45 43 54 4f 52 53 3a | 20 0d 0a 20 20 ed e9 fb |NECTORS:| .. ...|
|00000750| fe b9 08 00 16 07 8d 7e | f0 8e da f3 a5 16 1f b9 |.......~|........|
|00000760| 08 00 83 ec 10 89 e7 8d | 76 f0 f3 a5 8b 07 e8 cd |........|v.......|
|00000770| eb e9 d8 fe 6f 01 06 40 | 30 00 cf ff 15 00 00 00 |....o..@|0.......|
|00000780| 00 00 00 01 00 00 02 9f | 54 68 69 73 20 69 73 20 |........|This is |
|00000790| 61 20 63 75 73 74 6f 6d | 20 65 78 70 72 65 73 73 |a custom| express|
|000007a0| 69 6f 6e 20 62 75 69 6c | 64 65 72 2e 0d 0a 0d 0a |ion buil|der.....|
|000007b0| 41 6e 20 65 78 70 72 65 | 73 73 69 6f 6e 20 69 73 |An expre|ssion is|
|000007c0| 20 6f 6e 65 20 6f 72 20 | 6d 6f 72 65 20 73 65 6c | one or |more sel|
|000007d0| 65 63 74 69 6f 6e 20 63 | 72 69 74 65 72 69 61 20 |ection c|riteria |
|000007e0| 63 6f 6d 62 69 6e 65 64 | 2e 0d 0a 0d 0a 45 61 63 |combined|.....Eac|
|000007f0| 68 20 73 65 6c 65 63 74 | 69 6f 6e 20 63 72 69 74 |h select|ion crit|
|00000800| 65 72 69 6f 6e 20 77 69 | 6c 6c 20 62 65 20 63 61 |erion wi|ll be ca|
|00000810| 6c 6c 65 64 20 61 20 70 | 68 72 61 73 65 2e 0d 0a |lled a p|hrase...|
|00000820| 0d 0a 41 20 70 68 72 61 | 73 65 20 69 73 20 6d 61 |..A phra|se is ma|
|00000830| 64 65 20 75 70 20 6f 66 | 20 74 68 65 20 66 6f 6c |de up of| the fol|
|00000840| 6c 6f 77 69 6e 67 3a 0d | 0a 09 31 2e 20 46 49 45 |lowing:.|..1. FIE|
|00000850| 4c 44 5f 4e 41 4d 45 20 | 20 73 75 63 68 20 61 73 |LD_NAME | such as|
|00000860| 20 22 4c 41 53 54 5f 4e | 41 4d 45 22 20 20 20 20 | "LAST_N|AME" |
|00000870| 20 20 20 20 0d 0a 09 32 | 2e 20 4f 50 45 52 41 54 | ...2|. OPERAT|
|00000880| 4f 52 20 20 20 20 73 75 | 63 68 20 61 73 20 22 62 |OR su|ch as "b|
|00000890| 65 67 69 6e 73 20 77 69 | 74 68 22 20 20 0d 0a 09 |egins wi|th" ...|
|000008a0| 33 2e 20 44 41 54 41 20 | 20 20 20 20 20 20 20 73 |3. DATA | s|
|000008b0| 75 63 68 20 61 73 20 22 | 53 6d 69 74 68 22 20 20 |uch as "|Smith" |
|000008c0| 0d 0a 09 0d 0a 09 45 78 | 61 6d 70 6c 65 3a 20 20 |......Ex|ample: |
|000008d0| 46 49 45 4c 44 5f 4e 41 | 4d 45 20 20 20 4f 50 45 |FIELD_NA|ME OPE|
|000008e0| 52 41 54 4f 52 20 20 20 | 20 44 41 54 41 0d 0a 09 |RATOR | DATA...|
|000008f0| 20 20 20 20 20 20 20 20 | 20 20 4c 41 53 54 5f 4e | | LAST_N|
|00000900| 41 4d 45 20 20 20 20 62 | 65 67 69 6e 73 20 77 69 |AME b|egins wi|
|00000910| 74 68 20 22 53 6d 69 74 | 68 22 0d 0a 0d 0a 41 6e |th "Smit|h"....An|
|00000920| 20 65 78 70 72 65 73 73 | 69 6f 6e 20 6d 61 79 20 | express|ion may |
|00000930| 68 61 76 65 20 6d 6f 72 | 65 20 74 68 61 6e 20 6f |have mor|e than o|
|00000940| 6e 65 20 70 68 72 61 73 | 65 2e 20 54 68 69 73 20 |ne phras|e. This |
|00000950| 61 6c 6c 6f 77 73 20 79 | 6f 75 20 74 6f 20 63 72 |allows y|ou to cr|
|00000960| 65 61 74 65 0d 0a 73 6f | 6d 65 20 76 65 72 79 20 |eate..so|me very |
|00000970| 73 6f 70 68 69 73 74 69 | 63 61 74 65 64 20 73 65 |sophisti|cated se|
|00000980| 6c 65 63 74 69 6f 6e 20 | 63 72 69 74 65 72 69 61 |lection |criteria|
|00000990| 2e 0d 0a 0d 0a 50 68 72 | 61 73 65 73 20 61 72 65 |.....Phr|ases are|
|000009a0| 20 63 6f 6d 62 69 6e 65 | 64 20 77 69 74 68 20 74 | combine|d with t|
|000009b0| 68 65 20 66 6f 6c 6c 6f | 77 69 6e 67 20 43 4f 4e |he follo|wing CON|
|000009c0| 4e 45 43 54 4f 52 53 3a | 20 0d 0a 09 31 2e 20 41 |NECTORS:| ...1. A|
|000009d0| 4e 44 20 2d 6d 65 61 6e | 73 20 62 6f 74 68 20 70 |ND -mean|s both p|
|000009e0| 68 72 61 73 65 73 20 6d | 75 73 74 20 62 65 20 74 |hrases m|ust be t|
|000009f0| 72 75 65 20 20 0d 0a 09 | 32 2e 20 4f 52 20 20 2d |rue ...|2. OR -|
|00000a00| 6d 65 61 6e 73 20 6f 6e | 65 20 6f 66 20 74 68 65 |means on|e of the|
|00000a10| 20 70 68 72 61 73 65 73 | 20 6d 75 73 74 20 62 65 | phrases| must be|
|00000a20| 20 74 72 75 65 20 20 01 | c6 b9 08 00 16 07 8d 7e | true .|.......~|
|00000a30| e4 8e da 8d 74 02 f3 a5 | 16 1f 8b 5e e0 8b 47 0a |....t...|...^..G.|
|00000a40| 00 00 00 01 00 00 02 cc | 54 68 69 73 20 69 73 20 |........|This is |
|00000a50| 61 20 63 75 73 74 6f 6d | 20 65 78 70 72 65 73 73 |a custom| express|
|00000a60| 69 6f 6e 20 62 75 69 6c | 64 65 72 2e 0d 0a 0d 0a |ion buil|der.....|
|00000a70| 41 6e 20 65 78 70 72 65 | 73 73 69 6f 6e 20 69 73 |An expre|ssion is|
|00000a80| 20 6f 6e 65 20 6f 72 20 | 6d 6f 72 65 20 73 65 6c | one or |more sel|
|00000a90| 65 63 74 69 6f 6e 20 63 | 72 69 74 65 72 69 61 20 |ection c|riteria |
|00000aa0| 63 6f 6d 62 69 6e 65 64 | 2e 0d 0a 0d 0a 45 61 63 |combined|.....Eac|
|00000ab0| 68 20 73 65 6c 65 63 74 | 69 6f 6e 20 63 72 69 74 |h select|ion crit|
|00000ac0| 65 72 69 6f 6e 20 77 69 | 6c 6c 20 62 65 20 63 61 |erion wi|ll be ca|
|00000ad0| 6c 6c 65 64 20 61 20 70 | 68 72 61 73 65 2e 0d 0a |lled a p|hrase...|
|00000ae0| 0d 0a 41 20 70 68 72 61 | 73 65 20 69 73 20 6d 61 |..A phra|se is ma|
|00000af0| 64 65 20 75 70 20 6f 66 | 20 74 68 65 20 66 6f 6c |de up of| the fol|
|00000b00| 6c 6f 77 69 6e 67 3a 0d | 0a 09 31 2e 20 46 49 45 |lowing:.|..1. FIE|
|00000b10| 4c 44 5f 4e 41 4d 45 20 | 20 73 75 63 68 20 61 73 |LD_NAME | such as|
|00000b20| 20 22 4c 41 53 54 5f 4e | 41 4d 45 22 20 20 20 20 | "LAST_N|AME" |
|00000b30| 20 20 20 20 0d 0a 09 32 | 2e 20 4f 50 45 52 41 54 | ...2|. OPERAT|
|00000b40| 4f 52 20 20 20 20 73 75 | 63 68 20 61 73 20 22 62 |OR su|ch as "b|
|00000b50| 65 67 69 6e 73 20 77 69 | 74 68 22 20 20 0d 0a 09 |egins wi|th" ...|
|00000b60| 33 2e 20 44 41 54 41 20 | 20 20 20 20 20 20 20 73 |3. DATA | s|
|00000b70| 75 63 68 20 61 73 20 22 | 53 6d 69 74 68 22 20 20 |uch as "|Smith" |
|00000b80| 0d 0a 09 0d 0a 09 45 78 | 61 6d 70 6c 65 3a 20 20 |......Ex|ample: |
|00000b90| 46 49 45 4c 44 5f 4e 41 | 4d 45 20 20 20 4f 50 45 |FIELD_NA|ME OPE|
|00000ba0| 52 41 54 4f 52 20 20 20 | 20 44 41 54 41 0d 0a 09 |RATOR | DATA...|
|00000bb0| 20 20 20 20 20 20 20 20 | 20 20 4c 41 53 54 5f 4e | | LAST_N|
|00000bc0| 41 4d 45 20 20 20 20 62 | 65 67 69 6e 73 20 77 69 |AME b|egins wi|
|00000bd0| 74 68 20 22 53 6d 69 74 | 68 22 0d 0a 0d 0a 41 6e |th "Smit|h"....An|
|00000be0| 20 65 78 70 72 65 73 73 | 69 6f 6e 20 6d 61 79 20 | express|ion may |
|00000bf0| 68 61 76 65 20 6d 6f 72 | 65 20 74 68 61 6e 20 6f |have mor|e than o|
|00000c00| 6e 65 20 70 68 72 61 73 | 65 2e 20 54 68 69 73 20 |ne phras|e. This |
|00000c10| 61 6c 6c 6f 77 73 20 79 | 6f 75 20 74 6f 20 63 72 |allows y|ou to cr|
|00000c20| 65 61 74 65 0d 0a 73 6f | 6d 65 20 76 65 72 79 20 |eate..so|me very |
|00000c30| 73 6f 70 68 69 73 74 69 | 63 61 74 65 64 20 73 65 |sophisti|cated se|
|00000c40| 6c 65 63 74 69 6f 6e 20 | 63 72 69 74 65 72 69 61 |lection |criteria|
|00000c50| 2e 0d 0a 0d 0a 50 68 72 | 61 73 65 73 20 61 72 65 |.....Phr|ases are|
|00000c60| 20 63 6f 6d 62 69 6e 65 | 64 20 77 69 74 68 20 74 | combine|d with t|
|00000c70| 68 65 20 66 6f 6c 6c 6f | 77 69 6e 67 20 43 4f 4e |he follo|wing CON|
|00000c80| 4e 45 43 54 4f 52 53 3a | 20 0d 0a 09 31 2e 20 41 |NECTORS:| ...1. A|
|00000c90| 4e 44 20 2d 6d 65 61 6e | 73 20 62 6f 74 68 20 70 |ND -mean|s both p|
|00000ca0| 68 72 61 73 65 73 20 6d | 75 73 74 20 62 65 20 74 |hrases m|ust be t|
|00000cb0| 72 75 65 20 20 0d 0a 09 | 32 2e 20 4f 52 20 20 2d |rue ...|2. OR -|
|00000cc0| 6d 65 61 6e 73 20 6f 6e | 65 20 6f 66 20 74 68 65 |means on|e of the|
|00000cd0| 20 70 68 72 61 73 65 73 | 20 6d 75 73 74 20 62 65 | phrases| must be|
|00000ce0| 20 74 72 75 65 20 20 0d | 0a 09 0d 0a 50 68 72 61 | true .|....Phra|
|00000cf0| 73 65 73 20 6d 61 79 20 | 62 65 20 70 75 74 20 69 |ses may |be put i|
|00000d00| 6e 20 64 69 66 66 65 72 | 65 6e 74 20 67 72 6f 75 |n differ|ent grou|
|00000d10| 70 73 2e 09 07 75 16 3b | 46 fe 72 11 89 f0 9a b3 |ps...u.;|F.r.....|
|00000d20| 2c 55 43 3b 46 fc 75 05 | c7 46 f6 00 00 8b 47 02 |,UC;F.u.|.F....G.|
|00000d30| 8b 57 04 a3 08 39 89 16 | 0a 39 eb 05 c7 46 f6 00 |.W...9..|.9...F..|
|00000d40| 00 00 00 01 00 00 03 ab | 54 68 69 73 20 69 73 20 |........|This is |
|00000d50| 61 20 63 75 73 74 6f 6d | 20 65 78 70 72 65 73 73 |a custom| express|
|00000d60| 69 6f 6e 20 62 75 69 6c | 64 65 72 2e 0d 0a 0d 0a |ion buil|der.....|
|00000d70| 41 6e 20 65 78 70 72 65 | 73 73 69 6f 6e 20 69 73 |An expre|ssion is|
|00000d80| 20 6f 6e 65 20 6f 72 20 | 6d 6f 72 65 20 73 65 6c | one or |more sel|
|00000d90| 65 63 74 69 6f 6e 20 63 | 72 69 74 65 72 69 61 20 |ection c|riteria |
|00000da0| 63 6f 6d 62 69 6e 65 64 | 2e 0d 0a 0d 0a 45 61 63 |combined|.....Eac|
|00000db0| 68 20 73 65 6c 65 63 74 | 69 6f 6e 20 63 72 69 74 |h select|ion crit|
|00000dc0| 65 72 69 6f 6e 20 77 69 | 6c 6c 20 62 65 20 63 61 |erion wi|ll be ca|
|00000dd0| 6c 6c 65 64 20 61 20 70 | 68 72 61 73 65 2e 0d 0a |lled a p|hrase...|
|00000de0| 0d 0a 41 20 70 68 72 61 | 73 65 20 69 73 20 6d 61 |..A phra|se is ma|
|00000df0| 64 65 20 75 70 20 6f 66 | 20 74 68 65 20 66 6f 6c |de up of| the fol|
|00000e00| 6c 6f 77 69 6e 67 3a 0d | 0a 09 31 2e 20 46 49 45 |lowing:.|..1. FIE|
|00000e10| 4c 44 5f 4e 41 4d 45 20 | 20 73 75 63 68 20 61 73 |LD_NAME | such as|
|00000e20| 20 22 4c 41 53 54 5f 4e | 41 4d 45 22 20 20 20 20 | "LAST_N|AME" |
|00000e30| 20 20 20 20 0d 0a 09 32 | 2e 20 4f 50 45 52 41 54 | ...2|. OPERAT|
|00000e40| 4f 52 20 20 20 20 73 75 | 63 68 20 61 73 20 22 62 |OR su|ch as "b|
|00000e50| 65 67 69 6e 73 20 77 69 | 74 68 22 20 20 0d 0a 09 |egins wi|th" ...|
|00000e60| 33 2e 20 44 41 54 41 20 | 20 20 20 20 20 20 20 73 |3. DATA | s|
|00000e70| 75 63 68 20 61 73 20 22 | 53 6d 69 74 68 22 20 20 |uch as "|Smith" |
|00000e80| 0d 0a 09 0d 0a 09 45 78 | 61 6d 70 6c 65 3a 20 20 |......Ex|ample: |
|00000e90| 46 49 45 4c 44 5f 4e 41 | 4d 45 20 20 20 4f 50 45 |FIELD_NA|ME OPE|
|00000ea0| 52 41 54 4f 52 20 20 20 | 20 44 41 54 41 0d 0a 09 |RATOR | DATA...|
|00000eb0| 20 20 20 20 20 20 20 20 | 20 20 4c 41 53 54 5f 4e | | LAST_N|
|00000ec0| 41 4d 45 20 20 20 20 62 | 65 67 69 6e 73 20 77 69 |AME b|egins wi|
|00000ed0| 74 68 20 22 53 6d 69 74 | 68 22 0d 0a 0d 0a 41 6e |th "Smit|h"....An|
|00000ee0| 20 65 78 70 72 65 73 73 | 69 6f 6e 20 6d 61 79 20 | express|ion may |
|00000ef0| 68 61 76 65 20 6d 6f 72 | 65 20 74 68 61 6e 20 6f |have mor|e than o|
|00000f00| 6e 65 20 70 68 72 61 73 | 65 2e 20 54 68 69 73 20 |ne phras|e. This |
|00000f10| 61 6c 6c 6f 77 73 20 79 | 6f 75 20 74 6f 20 63 72 |allows y|ou to cr|
|00000f20| 65 61 74 65 0d 0a 73 6f | 6d 65 20 76 65 72 79 20 |eate..so|me very |
|00000f30| 73 6f 70 68 69 73 74 69 | 63 61 74 65 64 20 73 65 |sophisti|cated se|
|00000f40| 6c 65 63 74 69 6f 6e 20 | 63 72 69 74 65 72 69 61 |lection |criteria|
|00000f50| 2e 0d 0a 0d 0a 50 68 72 | 61 73 65 73 20 61 72 65 |.....Phr|ases are|
|00000f60| 20 63 6f 6d 62 69 6e 65 | 64 20 77 69 74 68 20 74 | combine|d with t|
|00000f70| 68 65 20 66 6f 6c 6c 6f | 77 69 6e 67 20 43 4f 4e |he follo|wing CON|
|00000f80| 4e 45 43 54 4f 52 53 3a | 20 0d 0a 09 31 2e 20 41 |NECTORS:| ...1. A|
|00000f90| 4e 44 20 2d 6d 65 61 6e | 73 20 62 6f 74 68 20 70 |ND -mean|s both p|
|00000fa0| 68 72 61 73 65 73 20 6d | 75 73 74 20 62 65 20 74 |hrases m|ust be t|
|00000fb0| 72 75 65 20 20 0d 0a 09 | 32 2e 20 4f 52 20 20 2d |rue ...|2. OR -|
|00000fc0| 6d 65 61 6e 73 20 6f 6e | 65 20 6f 66 20 74 68 65 |means on|e of the|
|00000fd0| 20 70 68 72 61 73 65 73 | 20 6d 75 73 74 20 62 65 | phrases| must be|
|00000fe0| 20 74 72 75 65 20 20 0d | 0a 09 0d 0a 50 68 72 61 | true .|....Phra|
|00000ff0| 73 65 73 20 6d 61 79 20 | 62 65 20 70 75 74 20 69 |ses may |be put i|
|00001000| 6e 20 64 69 66 66 65 72 | 65 6e 74 20 67 72 6f 75 |n differ|ent grou|
|00001010| 70 73 2e 20 54 68 65 20 | 70 68 72 61 73 65 73 20 |ps. The |phrases |
|00001020| 69 6e 20 74 68 65 20 31 | 73 74 20 67 72 6f 75 70 |in the 1|st group|
|00001030| 20 61 72 65 0d 0a 65 76 | 61 6c 75 61 74 65 64 20 | are..ev|aluated |
|00001040| 61 73 20 61 20 67 72 6f | 75 70 20 62 65 66 6f 72 |as a gro|up befor|
|00001050| 65 20 74 68 65 20 70 68 | 72 61 73 65 73 20 69 6e |e the ph|rases in|
|00001060| 20 74 68 65 20 32 6e 64 | 20 67 72 6f 75 70 20 61 | the 2nd| group a|
|00001070| 72 65 20 65 76 61 6c 75 | 61 74 65 64 2c 20 61 6e |re evalu|ated, an|
|00001080| 64 20 74 68 65 20 70 68 | 72 61 73 65 73 20 69 6e |d the ph|rases in|
|00001090| 20 74 68 65 20 32 6e 64 | 20 67 72 6f 75 70 20 61 | the 2nd| group a|
|000010a0| 72 65 20 65 76 61 6c 75 | 61 74 65 64 20 61 73 20 |re evalu|ated as |
|000010b0| 61 20 67 72 6f 75 70 20 | 62 65 66 6f 72 65 20 74 |a group |before t|
|000010c0| 68 65 20 70 68 72 61 73 | 65 73 20 69 6e 20 74 68 |he phras|es in th|
|000010d0| 65 20 33 72 64 20 67 72 | 6f 75 70 20 61 72 65 20 |e 3rd gr|oup are |
|000010e0| 65 76 61 6c 75 61 74 65 | 64 2c 20 65 74 63 2e 2e |evaluate|d, etc..|
|000010f0| 2e 0d 0a 20 6f 66 20 74 | 68 65 20 54 75 74 6f 72 |... of t|he Tutor|
|00001100| 00 00 00 01 00 00 04 28 | 54 68 69 73 20 69 73 20 |.......(|This is |
|00001110| 61 20 63 75 73 74 6f 6d | 20 65 78 70 72 65 73 73 |a custom| express|
|00001120| 69 6f 6e 20 62 75 69 6c | 64 65 72 2e 0d 0a 0d 0a |ion buil|der.....|
|00001130| 41 6e 20 65 78 70 72 65 | 73 73 69 6f 6e 20 69 73 |An expre|ssion is|
|00001140| 20 6f 6e 65 20 6f 72 20 | 6d 6f 72 65 20 73 65 6c | one or |more sel|
|00001150| 65 63 74 69 6f 6e 20 63 | 72 69 74 65 72 69 61 20 |ection c|riteria |
|00001160| 63 6f 6d 62 69 6e 65 64 | 2e 0d 0a 0d 0a 45 61 63 |combined|.....Eac|
|00001170| 68 20 73 65 6c 65 63 74 | 69 6f 6e 20 63 72 69 74 |h select|ion crit|
|00001180| 65 72 69 6f 6e 20 77 69 | 6c 6c 20 62 65 20 63 61 |erion wi|ll be ca|
|00001190| 6c 6c 65 64 20 61 20 70 | 68 72 61 73 65 2e 0d 0a |lled a p|hrase...|
|000011a0| 0d 0a 41 20 70 68 72 61 | 73 65 20 69 73 20 6d 61 |..A phra|se is ma|
|000011b0| 64 65 20 75 70 20 6f 66 | 20 74 68 65 20 66 6f 6c |de up of| the fol|
|000011c0| 6c 6f 77 69 6e 67 3a 0d | 0a 09 31 2e 20 46 49 45 |lowing:.|..1. FIE|
|000011d0| 4c 44 5f 4e 41 4d 45 20 | 20 73 75 63 68 20 61 73 |LD_NAME | such as|
|000011e0| 20 22 4c 41 53 54 5f 4e | 41 4d 45 22 20 20 20 20 | "LAST_N|AME" |
|000011f0| 20 20 20 20 0d 0a 09 32 | 2e 20 4f 50 45 52 41 54 | ...2|. OPERAT|
|00001200| 4f 52 20 20 20 20 73 75 | 63 68 20 61 73 20 22 62 |OR su|ch as "b|
|00001210| 65 67 69 6e 73 20 77 69 | 74 68 22 20 20 0d 0a 09 |egins wi|th" ...|
|00001220| 33 2e 20 44 41 54 41 20 | 20 20 20 20 20 20 20 73 |3. DATA | s|
|00001230| 75 63 68 20 61 73 20 22 | 53 6d 69 74 68 22 20 20 |uch as "|Smith" |
|00001240| 0d 0a 09 0d 0a 09 45 78 | 61 6d 70 6c 65 3a 20 20 |......Ex|ample: |
|00001250| 46 49 45 4c 44 5f 4e 41 | 4d 45 20 20 20 4f 50 45 |FIELD_NA|ME OPE|
|00001260| 52 41 54 4f 52 20 20 20 | 20 44 41 54 41 0d 0a 09 |RATOR | DATA...|
|00001270| 20 20 20 20 20 20 20 20 | 20 20 4c 41 53 54 5f 4e | | LAST_N|
|00001280| 41 4d 45 20 20 20 20 62 | 65 67 69 6e 73 20 77 69 |AME b|egins wi|
|00001290| 74 68 20 22 53 6d 69 74 | 68 22 0d 0a 0d 0a 41 6e |th "Smit|h"....An|
|000012a0| 20 65 78 70 72 65 73 73 | 69 6f 6e 20 6d 61 79 20 | express|ion may |
|000012b0| 68 61 76 65 20 6d 6f 72 | 65 20 74 68 61 6e 20 6f |have mor|e than o|
|000012c0| 6e 65 20 70 68 72 61 73 | 65 2e 20 54 68 69 73 20 |ne phras|e. This |
|000012d0| 61 6c 6c 6f 77 73 20 79 | 6f 75 20 74 6f 20 63 72 |allows y|ou to cr|
|000012e0| 65 61 74 65 0d 0a 73 6f | 6d 65 20 76 65 72 79 20 |eate..so|me very |
|000012f0| 73 6f 70 68 69 73 74 69 | 63 61 74 65 64 20 73 65 |sophisti|cated se|
|00001300| 6c 65 63 74 69 6f 6e 20 | 63 72 69 74 65 72 69 61 |lection |criteria|
|00001310| 2e 0d 0a 0d 0a 50 68 72 | 61 73 65 73 20 61 72 65 |.....Phr|ases are|
|00001320| 20 63 6f 6d 62 69 6e 65 | 64 20 77 69 74 68 20 74 | combine|d with t|
|00001330| 68 65 20 66 6f 6c 6c 6f | 77 69 6e 67 20 43 4f 4e |he follo|wing CON|
|00001340| 4e 45 43 54 4f 52 53 3a | 20 0d 0a 09 31 2e 20 41 |NECTORS:| ...1. A|
|00001350| 4e 44 20 2d 6d 65 61 6e | 73 20 62 6f 74 68 20 70 |ND -mean|s both p|
|00001360| 68 72 61 73 65 73 20 6d | 75 73 74 20 62 65 20 74 |hrases m|ust be t|
|00001370| 72 75 65 20 20 0d 0a 09 | 32 2e 20 4f 52 20 20 2d |rue ...|2. OR -|
|00001380| 6d 65 61 6e 73 20 6f 6e | 65 20 6f 66 20 74 68 65 |means on|e of the|
|00001390| 20 70 68 72 61 73 65 73 | 20 6d 75 73 74 20 62 65 | phrases| must be|
|000013a0| 20 74 72 75 65 20 20 0d | 0a 09 0d 0a 50 68 72 61 | true .|....Phra|
|000013b0| 73 65 73 20 6d 61 79 20 | 62 65 20 70 75 74 20 69 |ses may |be put i|
|000013c0| 6e 20 64 69 66 66 65 72 | 65 6e 74 20 67 72 6f 75 |n differ|ent grou|
|000013d0| 70 73 2e 20 54 68 65 20 | 70 68 72 61 73 65 73 20 |ps. The |phrases |
|000013e0| 69 6e 20 74 68 65 20 31 | 73 74 20 67 72 6f 75 70 |in the 1|st group|
|000013f0| 20 61 72 65 0d 0a 65 76 | 61 6c 75 61 74 65 64 20 | are..ev|aluated |
|00001400| 61 73 20 61 20 67 72 6f | 75 70 20 62 65 66 6f 72 |as a gro|up befor|
|00001410| 65 20 74 68 65 20 70 68 | 72 61 73 65 73 20 69 6e |e the ph|rases in|
|00001420| 20 74 68 65 20 32 6e 64 | 20 67 72 6f 75 70 20 61 | the 2nd| group a|
|00001430| 72 65 20 65 76 61 6c 75 | 61 74 65 64 2c 20 61 6e |re evalu|ated, an|
|00001440| 64 20 74 68 65 20 70 68 | 72 61 73 65 73 20 69 6e |d the ph|rases in|
|00001450| 20 74 68 65 20 32 6e 64 | 20 67 72 6f 75 70 20 61 | the 2nd| group a|
|00001460| 72 65 20 65 76 61 6c 75 | 61 74 65 64 20 61 73 20 |re evalu|ated as |
|00001470| 61 20 67 72 6f 75 70 20 | 62 65 66 6f 72 65 20 74 |a group |before t|
|00001480| 68 65 20 70 68 72 61 73 | 65 73 20 69 6e 20 74 68 |he phras|es in th|
|00001490| 65 20 33 72 64 20 67 72 | 6f 75 70 20 61 72 65 20 |e 3rd gr|oup are |
|000014a0| 65 76 61 6c 75 61 74 65 | 64 2c 20 65 74 63 2e 2e |evaluate|d, etc..|
|000014b0| 2e 0d 0a 0d 0a 50 75 74 | 74 69 6e 67 20 70 68 72 |.....Put|ting phr|
|000014c0| 61 73 65 73 20 69 6e 20 | 61 20 64 69 66 66 65 72 |ases in |a differ|
|000014d0| 65 6e 74 20 67 72 6f 75 | 70 20 77 69 6c 6c 20 6e |ent grou|p will n|
|000014e0| 6f 72 6d 61 6c 6c 79 20 | 6e 6f 74 20 62 65 20 6e |ormally |not be n|
|000014f0| 65 63 65 73 73 61 72 79 | 20 75 6e 6c 65 73 73 20 |ecessary| unless |
|00001500| 74 68 65 20 73 65 6c 65 | 63 74 69 6f 6e 20 63 72 |the sele|ction cr|
|00001510| 69 74 65 72 69 61 20 61 | 72 65 20 76 65 72 79 20 |iteria a|re very |
|00001520| 63 6f 6d 70 6c 69 63 61 | 74 65 64 2e 0d 0a 0d 0a |complica|ted.....|
|00001530| 74 68 22 20 20 0d 09 33 | 2e 20 44 41 54 41 20 20 |th" ..3|. DATA |
|00001540| 00 00 00 01 00 00 04 d4 | 54 68 69 73 20 69 73 20 |........|This is |
|00001550| 61 20 63 75 73 74 6f 6d | 20 65 78 70 72 65 73 73 |a custom| express|
|00001560| 69 6f 6e 20 62 75 69 6c | 64 65 72 2e 0d 0a 0d 0a |ion buil|der.....|
|00001570| 41 6e 20 65 78 70 72 65 | 73 73 69 6f 6e 20 69 73 |An expre|ssion is|
|00001580| 20 6f 6e 65 20 6f 72 20 | 6d 6f 72 65 20 73 65 6c | one or |more sel|
|00001590| 65 63 74 69 6f 6e 20 63 | 72 69 74 65 72 69 61 20 |ection c|riteria |
|000015a0| 63 6f 6d 62 69 6e 65 64 | 2e 0d 0a 0d 0a 45 61 63 |combined|.....Eac|
|000015b0| 68 20 73 65 6c 65 63 74 | 69 6f 6e 20 63 72 69 74 |h select|ion crit|
|000015c0| 65 72 69 6f 6e 20 77 69 | 6c 6c 20 62 65 20 63 61 |erion wi|ll be ca|
|000015d0| 6c 6c 65 64 20 61 20 70 | 68 72 61 73 65 2e 0d 0a |lled a p|hrase...|
|000015e0| 0d 0a 41 20 70 68 72 61 | 73 65 20 69 73 20 6d 61 |..A phra|se is ma|
|000015f0| 64 65 20 75 70 20 6f 66 | 20 74 68 65 20 66 6f 6c |de up of| the fol|
|00001600| 6c 6f 77 69 6e 67 3a 0d | 0a 09 31 2e 20 46 49 45 |lowing:.|..1. FIE|
|00001610| 4c 44 5f 4e 41 4d 45 20 | 20 73 75 63 68 20 61 73 |LD_NAME | such as|
|00001620| 20 22 4c 41 53 54 5f 4e | 41 4d 45 22 20 20 20 20 | "LAST_N|AME" |
|00001630| 20 20 20 20 0d 0a 09 32 | 2e 20 4f 50 45 52 41 54 | ...2|. OPERAT|
|00001640| 4f 52 20 20 20 20 73 75 | 63 68 20 61 73 20 22 62 |OR su|ch as "b|
|00001650| 65 67 69 6e 73 20 77 69 | 74 68 22 20 20 0d 0a 09 |egins wi|th" ...|
|00001660| 33 2e 20 44 41 54 41 20 | 20 20 20 20 20 20 20 73 |3. DATA | s|
|00001670| 75 63 68 20 61 73 20 22 | 53 6d 69 74 68 22 20 20 |uch as "|Smith" |
|00001680| 0d 0a 09 0d 0a 09 45 78 | 61 6d 70 6c 65 3a 20 20 |......Ex|ample: |
|00001690| 46 49 45 4c 44 5f 4e 41 | 4d 45 20 20 20 4f 50 45 |FIELD_NA|ME OPE|
|000016a0| 52 41 54 4f 52 20 20 20 | 20 44 41 54 41 0d 0a 09 |RATOR | DATA...|
|000016b0| 20 20 20 20 20 20 20 20 | 20 20 4c 41 53 54 5f 4e | | LAST_N|
|000016c0| 41 4d 45 20 20 20 20 62 | 65 67 69 6e 73 20 77 69 |AME b|egins wi|
|000016d0| 74 68 20 22 53 6d 69 74 | 68 22 0d 0a 0d 0a 41 6e |th "Smit|h"....An|
|000016e0| 20 65 78 70 72 65 73 73 | 69 6f 6e 20 6d 61 79 20 | express|ion may |
|000016f0| 68 61 76 65 20 6d 6f 72 | 65 20 74 68 61 6e 20 6f |have mor|e than o|
|00001700| 6e 65 20 70 68 72 61 73 | 65 2e 20 54 68 69 73 20 |ne phras|e. This |
|00001710| 61 6c 6c 6f 77 73 20 79 | 6f 75 20 74 6f 20 63 72 |allows y|ou to cr|
|00001720| 65 61 74 65 0d 0a 73 6f | 6d 65 20 76 65 72 79 20 |eate..so|me very |
|00001730| 73 6f 70 68 69 73 74 69 | 63 61 74 65 64 20 73 65 |sophisti|cated se|
|00001740| 6c 65 63 74 69 6f 6e 20 | 63 72 69 74 65 72 69 61 |lection |criteria|
|00001750| 2e 0d 0a 0d 0a 50 68 72 | 61 73 65 73 20 61 72 65 |.....Phr|ases are|
|00001760| 20 63 6f 6d 62 69 6e 65 | 64 20 77 69 74 68 20 74 | combine|d with t|
|00001770| 68 65 20 66 6f 6c 6c 6f | 77 69 6e 67 20 43 4f 4e |he follo|wing CON|
|00001780| 4e 45 43 54 4f 52 53 3a | 20 0d 0a 09 31 2e 20 41 |NECTORS:| ...1. A|
|00001790| 4e 44 20 2d 6d 65 61 6e | 73 20 62 6f 74 68 20 70 |ND -mean|s both p|
|000017a0| 68 72 61 73 65 73 20 6d | 75 73 74 20 62 65 20 74 |hrases m|ust be t|
|000017b0| 72 75 65 20 20 0d 0a 09 | 32 2e 20 4f 52 20 20 2d |rue ...|2. OR -|
|000017c0| 6d 65 61 6e 73 20 6f 6e | 65 20 6f 66 20 74 68 65 |means on|e of the|
|000017d0| 20 70 68 72 61 73 65 73 | 20 6d 75 73 74 20 62 65 | phrases| must be|
|000017e0| 20 74 72 75 65 20 20 0d | 0a 09 0d 0a 09 45 78 61 | true .|.....Exa|
|000017f0| 6d 70 6c 65 3a 20 20 46 | 49 45 4c 44 5f 4e 41 4d |mple: F|IELD_NAM|
|00001800| 45 20 20 20 4f 50 45 52 | 41 54 4f 52 20 20 20 20 |E OPER|ATOR |
|00001810| 20 20 20 44 41 54 41 20 | 20 20 20 20 20 43 4f 4e | DATA | CON|
|00001820| 4e 45 43 54 4f 52 0d 0a | 09 20 20 20 20 20 20 20 |NECTOR..|. |
|00001830| 20 20 20 4c 41 53 54 5f | 4e 41 4d 45 20 20 20 20 | LAST_|NAME |
|00001840| 62 65 67 69 6e 73 20 77 | 69 74 68 20 20 20 20 22 |begins w|ith "|
|00001850| 53 6d 69 74 68 22 20 20 | 20 41 4e 44 0d 0a 09 20 |Smith" | AND... |
|00001860| 20 20 20 20 20 20 20 20 | 20 53 45 58 20 20 20 20 | | SEX |
|00001870| 20 20 20 20 20 20 69 73 | 20 74 68 65 20 73 61 6d | is| the sam|
|00001880| 65 20 61 73 20 20 22 46 | 45 4d 41 4c 45 22 0d 0a |e as "F|EMALE"..|
|00001890| 0d 0a 0d 0a 0d 0a 50 68 | 72 61 73 65 73 20 6d 61 |......Ph|rases ma|
|000018a0| 79 20 62 65 20 70 75 74 | 20 69 6e 20 64 69 66 66 |y be put| in diff|
|000018b0| 65 72 65 6e 74 20 67 72 | 6f 75 70 73 2e 20 54 68 |erent gr|oups. Th|
|000018c0| 65 20 70 68 72 61 73 65 | 73 20 69 6e 20 74 68 65 |e phrase|s in the|
|000018d0| 20 31 73 74 20 67 72 6f | 75 70 20 61 72 65 0d 0a | 1st gro|up are..|
|000018e0| 65 76 61 6c 75 61 74 65 | 64 20 61 73 20 61 20 67 |evaluate|d as a g|
|000018f0| 72 6f 75 70 20 62 65 66 | 6f 72 65 20 74 68 65 20 |roup bef|ore the |
|00001900| 70 68 72 61 73 65 73 20 | 69 6e 20 74 68 65 20 32 |phrases |in the 2|
|00001910| 6e 64 20 67 72 6f 75 70 | 20 61 72 65 20 65 76 61 |nd group| are eva|
|00001920| 6c 75 61 74 65 64 2c 20 | 61 6e 64 20 74 68 65 20 |luated, |and the |
|00001930| 70 68 72 61 73 65 73 20 | 69 6e 20 74 68 65 20 32 |phrases |in the 2|
|00001940| 6e 64 20 67 72 6f 75 70 | 20 61 72 65 20 65 76 61 |nd group| are eva|
|00001950| 6c 75 61 74 65 64 20 61 | 73 20 61 20 67 72 6f 75 |luated a|s a grou|
|00001960| 70 20 62 65 66 6f 72 65 | 20 74 68 65 20 70 68 72 |p before| the phr|
|00001970| 61 73 65 73 20 69 6e 20 | 74 68 65 20 33 72 64 20 |ases in |the 3rd |
|00001980| 67 72 6f 75 70 20 61 72 | 65 20 65 76 61 6c 75 61 |group ar|e evalua|
|00001990| 74 65 64 2c 20 65 74 63 | 2e 2e 2e 0d 0a 0d 0a 50 |ted, etc|.......P|
|000019a0| 75 74 74 69 6e 67 20 70 | 68 72 61 73 65 73 20 69 |utting p|hrases i|
|000019b0| 6e 20 61 20 64 69 66 66 | 65 72 65 6e 74 20 67 72 |n a diff|erent gr|
|000019c0| 6f 75 70 20 77 69 6c 6c | 20 6e 6f 72 6d 61 6c 6c |oup will| normall|
|000019d0| 79 20 6e 6f 74 20 62 65 | 20 6e 65 63 65 73 73 61 |y not be| necessa|
|000019e0| 72 79 20 75 6e 6c 65 73 | 73 20 74 68 65 20 73 65 |ry unles|s the se|
|000019f0| 6c 65 63 74 69 6f 6e 20 | 63 72 69 74 65 72 69 61 |lection |criteria|
|00001a00| 20 61 72 65 20 76 65 72 | 79 20 63 6f 6d 70 6c 69 | are ver|y compli|
|00001a10| 63 61 74 65 64 2e 0d 0a | 0d 0a 0d 0a e5 00 00 0c |cated...|........|
|00001a20| 00 01 00 00 00 8a cb 00 | 00 54 68 69 73 20 69 73 |........|.This is|
|00001a30| 20 61 20 63 75 73 74 6f | 6d 20 65 78 70 72 65 73 | a custo|m expres|
|00001a40| 00 00 00 01 00 00 06 a3 | 54 68 69 73 20 69 73 20 |........|This is |
|00001a50| 61 20 63 75 73 74 6f 6d | 20 65 78 70 72 65 73 73 |a custom| express|
|00001a60| 69 6f 6e 20 62 75 69 6c | 64 65 72 2e 0d 0a 0d 0a |ion buil|der.....|
|00001a70| 41 6e 20 65 78 70 72 65 | 73 73 69 6f 6e 20 69 73 |An expre|ssion is|
|00001a80| 20 6f 6e 65 20 6f 72 20 | 6d 6f 72 65 20 73 65 6c | one or |more sel|
|00001a90| 65 63 74 69 6f 6e 20 63 | 72 69 74 65 72 69 61 20 |ection c|riteria |
|00001aa0| 63 6f 6d 62 69 6e 65 64 | 2e 0d 0a 0d 0a 45 61 63 |combined|.....Eac|
|00001ab0| 68 20 73 65 6c 65 63 74 | 69 6f 6e 20 63 72 69 74 |h select|ion crit|
|00001ac0| 65 72 69 6f 6e 20 77 69 | 6c 6c 20 62 65 20 63 61 |erion wi|ll be ca|
|00001ad0| 6c 6c 65 64 20 61 20 70 | 68 72 61 73 65 2e 0d 0a |lled a p|hrase...|
|00001ae0| 0d 0a 41 20 70 68 72 61 | 73 65 20 69 73 20 6d 61 |..A phra|se is ma|
|00001af0| 64 65 20 75 70 20 6f 66 | 20 74 68 65 20 66 6f 6c |de up of| the fol|
|00001b00| 6c 6f 77 69 6e 67 3a 0d | 0a 09 31 2e 20 46 49 45 |lowing:.|..1. FIE|
|00001b10| 4c 44 5f 4e 41 4d 45 20 | 20 73 75 63 68 20 61 73 |LD_NAME | such as|
|00001b20| 20 22 4c 41 53 54 5f 4e | 41 4d 45 22 20 20 20 20 | "LAST_N|AME" |
|00001b30| 20 20 20 20 0d 0a 09 32 | 2e 20 4f 50 45 52 41 54 | ...2|. OPERAT|
|00001b40| 4f 52 20 20 20 20 73 75 | 63 68 20 61 73 20 22 62 |OR su|ch as "b|
|00001b50| 65 67 69 6e 73 20 77 69 | 74 68 22 20 20 0d 0a 09 |egins wi|th" ...|
|00001b60| 33 2e 20 44 41 54 41 20 | 20 20 20 20 20 20 20 73 |3. DATA | s|
|00001b70| 75 63 68 20 61 73 20 22 | 53 6d 69 74 68 22 20 20 |uch as "|Smith" |
|00001b80| 0d 0a 09 0d 0a 09 45 78 | 61 6d 70 6c 65 3a 20 20 |......Ex|ample: |
|00001b90| 46 49 45 4c 44 5f 4e 41 | 4d 45 20 20 20 4f 50 45 |FIELD_NA|ME OPE|
|00001ba0| 52 41 54 4f 52 20 20 20 | 20 44 41 54 41 0d 0a 09 |RATOR | DATA...|
|00001bb0| 20 20 20 20 20 20 20 20 | 20 20 4c 41 53 54 5f 4e | | LAST_N|
|00001bc0| 41 4d 45 20 20 20 20 62 | 65 67 69 6e 73 20 77 69 |AME b|egins wi|
|00001bd0| 74 68 20 22 53 6d 69 74 | 68 22 0d 0a 0d 0a 41 6e |th "Smit|h"....An|
|00001be0| 20 65 78 70 72 65 73 73 | 69 6f 6e 20 6d 61 79 20 | express|ion may |
|00001bf0| 68 61 76 65 20 6d 6f 72 | 65 20 74 68 61 6e 20 6f |have mor|e than o|
|00001c00| 6e 65 20 70 68 72 61 73 | 65 2e 20 54 68 69 73 20 |ne phras|e. This |
|00001c10| 61 6c 6c 6f 77 73 20 79 | 6f 75 20 74 6f 20 63 72 |allows y|ou to cr|
|00001c20| 65 61 74 65 0d 0a 73 6f | 6d 65 20 76 65 72 79 20 |eate..so|me very |
|00001c30| 73 6f 70 68 69 73 74 69 | 63 61 74 65 64 20 73 65 |sophisti|cated se|
|00001c40| 6c 65 63 74 69 6f 6e 20 | 63 72 69 74 65 72 69 61 |lection |criteria|
|00001c50| 2e 0d 0a 0d 0a 50 68 72 | 61 73 65 73 20 61 72 65 |.....Phr|ases are|
|00001c60| 20 63 6f 6d 62 69 6e 65 | 64 20 77 69 74 68 20 74 | combine|d with t|
|00001c70| 68 65 20 66 6f 6c 6c 6f | 77 69 6e 67 20 43 4f 4e |he follo|wing CON|
|00001c80| 4e 45 43 54 4f 52 53 3a | 20 0d 0a 09 31 2e 20 41 |NECTORS:| ...1. A|
|00001c90| 4e 44 20 2d 6d 65 61 6e | 73 20 62 6f 74 68 20 70 |ND -mean|s both p|
|00001ca0| 68 72 61 73 65 73 20 6d | 75 73 74 20 62 65 20 74 |hrases m|ust be t|
|00001cb0| 72 75 65 20 20 0d 0a 09 | 32 2e 20 4f 52 20 20 2d |rue ...|2. OR -|
|00001cc0| 6d 65 61 6e 73 20 6f 6e | 65 20 6f 66 20 74 68 65 |means on|e of the|
|00001cd0| 20 70 68 72 61 73 65 73 | 20 6d 75 73 74 20 62 65 | phrases| must be|
|00001ce0| 20 74 72 75 65 20 20 0d | 0a 09 0d 0a 09 45 78 61 | true .|.....Exa|
|00001cf0| 6d 70 6c 65 3a 20 20 46 | 49 45 4c 44 5f 4e 41 4d |mple: F|IELD_NAM|
|00001d00| 45 20 20 20 4f 50 45 52 | 41 54 4f 52 20 20 20 20 |E OPER|ATOR |
|00001d10| 20 20 20 20 44 41 54 41 | 20 20 20 20 20 20 43 4f | DATA| CO|
|00001d20| 4e 4e 45 43 54 4f 52 0d | 0a 09 20 20 20 20 20 20 |NNECTOR.|.. |
|00001d30| 20 20 20 20 4c 41 53 54 | 5f 4e 41 4d 45 20 20 20 | LAST|_NAME |
|00001d40| 20 62 65 67 69 6e 73 20 | 77 69 74 68 20 20 20 20 | begins |with |
|00001d50| 20 22 53 6d 69 74 68 22 | 20 20 20 41 4e 44 0d 0a | "Smith"| AND..|
|00001d60| 09 20 20 20 20 20 20 20 | 20 20 20 53 45 58 20 20 |. | SEX |
|00001d70| 20 20 20 20 20 20 20 20 | 69 73 20 74 68 65 20 73 | |is the s|
|00001d80| 61 6d 65 20 61 73 20 20 | 22 46 45 4d 41 4c 45 22 |ame as |"FEMALE"|
|00001d90| 0d 0a 0d 0a 49 6e 20 74 | 68 65 20 61 62 6f 76 65 |....In t|he above|
|00001da0| 20 65 78 61 6d 70 6c 65 | 20 74 68 65 20 70 65 72 | example| the per|
|00001db0| 73 6f 6e 20 6d 75 73 74 | 20 68 61 76 65 20 61 20 |son must| have a |
|00001dc0| 6c 61 73 74 20 6e 61 6d | 65 20 74 68 61 74 20 62 |last nam|e that b|
|00001dd0| 65 67 69 6e 73 20 77 69 | 74 68 0d 0a 22 53 6d 69 |egins wi|th.."Smi|
|00001de0| 74 68 22 20 20 41 4e 44 | 20 20 74 68 65 79 20 6d |th" AND| they m|
|00001df0| 75 73 74 20 62 65 20 61 | 20 66 65 6d 61 6c 65 2e |ust be a| female.|
|00001e00| 0d 0a 49 66 20 74 68 65 | 20 63 6f 6e 6e 65 63 74 |..If the| connect|
|00001e10| 6f 72 20 77 65 72 65 20 | 61 6e 20 22 4f 52 22 20 |or were |an "OR" |
|00001e20| 74 68 65 6e 20 74 68 65 | 20 70 65 72 73 6f 6e 20 |then the| person |
|00001e30| 6d 75 73 74 20 68 61 76 | 65 20 61 20 6c 61 73 74 |must hav|e a last|
|00001e40| 20 6e 61 6d 65 20 74 68 | 61 74 20 62 65 67 69 6e | name th|at begin|
|00001e50| 73 20 77 69 74 68 20 22 | 53 6d 69 74 68 22 20 20 |s with "|Smith" |
|00001e60| 4f 52 20 20 74 68 65 79 | 20 6d 75 73 74 20 62 65 |OR they| must be|
|00001e70| 20 61 20 66 65 6d 61 6c | 65 2e 0d 0a 41 20 6c 69 | a femal|e...A li|
|00001e80| 73 74 20 6f 66 20 70 65 | 6f 70 6c 65 20 62 61 73 |st of pe|ople bas|
|00001e90| 65 64 20 6f 6e 20 74 68 | 65 20 41 4e 44 20 43 4f |ed on th|e AND CO|
|00001ea0| 4e 4e 45 43 54 4f 52 20 | 77 6f 75 6c 64 20 62 65 |NNECTOR |would be|
|00001eb0| 20 66 65 6d 61 6c 65 73 | 20 77 68 6f 73 65 20 6c | females| whose l|
|00001ec0| 61 73 74 0d 0a 6e 61 6d | 65 73 20 62 65 67 69 6e |ast..nam|es begin|
|00001ed0| 20 77 69 74 68 20 22 53 | 6d 69 74 68 22 2e 0d 0a | with "S|mith"...|
|00001ee0| 41 20 6c 69 73 74 20 6f | 66 20 70 65 6f 70 6c 65 |A list o|f people|
|00001ef0| 20 62 61 73 65 64 20 6f | 6e 20 74 68 65 20 4f 52 | based o|n the OR|
|00001f00| 20 43 4f 4e 4e 45 43 54 | 4f 52 20 77 6f 75 6c 64 | CONNECT|OR would|
|00001f10| 20 62 65 20 61 6c 6c 20 | 66 65 6d 61 6c 65 73 20 | be all |females |
|00001f20| 6f 72 20 61 6e 79 62 6f | 64 79 20 77 68 6f 73 65 |or anybo|dy whose|
|00001f30| 20 6c 61 73 74 20 6e 61 | 6d 65 73 20 62 65 67 69 | last na|mes begi|
|00001f40| 6e 20 77 69 74 68 20 22 | 53 6d 69 74 68 22 28 6d |n with "|Smith"(m|
|00001f50| 61 6c 65 20 6f 72 20 66 | 65 6d 61 6c 65 29 2e 0d |ale or f|emale)..|
|00001f60| 0a 0d 0a 0d 0a 50 68 72 | 61 73 65 73 20 6d 61 79 |.....Phr|ases may|
|00001f70| 20 62 65 20 70 75 74 20 | 69 6e 20 64 69 66 66 65 | be put |in diffe|
|00001f80| 72 65 6e 74 20 67 72 6f | 75 70 73 2e 20 54 68 65 |rent gro|ups. The|
|00001f90| 20 70 68 72 61 73 65 73 | 20 69 6e 20 74 68 65 20 | phrases| in the |
|00001fa0| 31 73 74 20 67 72 6f 75 | 70 20 61 72 65 0d 0a 65 |1st grou|p are..e|
|00001fb0| 76 61 6c 75 61 74 65 64 | 20 61 73 20 61 20 67 72 |valuated| as a gr|
|00001fc0| 6f 75 70 20 62 65 66 6f | 72 65 20 74 68 65 20 70 |oup befo|re the p|
|00001fd0| 68 72 61 73 65 73 20 69 | 6e 20 74 68 65 20 32 6e |hrases i|n the 2n|
|00001fe0| 64 20 67 72 6f 75 70 20 | 61 72 65 20 65 76 61 6c |d group |are eval|
|00001ff0| 75 61 74 65 64 2c 20 61 | 6e 64 20 74 68 65 20 70 |uated, a|nd the p|
|00002000| 68 72 61 73 65 73 20 69 | 6e 20 74 68 65 20 32 6e |hrases i|n the 2n|
|00002010| 64 20 67 72 6f 75 70 20 | 61 72 65 20 65 76 61 6c |d group |are eval|
|00002020| 75 61 74 65 64 20 61 73 | 20 61 20 67 72 6f 75 70 |uated as| a group|
|00002030| 20 62 65 66 6f 72 65 20 | 74 68 65 20 70 68 72 61 | before |the phra|
|00002040| 73 65 73 20 69 6e 20 74 | 68 65 20 33 72 64 20 67 |ses in t|he 3rd g|
|00002050| 72 6f 75 70 20 61 72 65 | 20 65 76 61 6c 75 61 74 |roup are| evaluat|
|00002060| 65 64 2c 20 65 74 63 2e | 2e 2e 0d 0a 0d 0a 50 75 |ed, etc.|......Pu|
|00002070| 74 74 69 6e 67 20 70 68 | 72 61 73 65 73 20 69 6e |tting ph|rases in|
|00002080| 20 61 20 64 69 66 66 65 | 72 65 6e 74 20 67 72 6f | a diffe|rent gro|
|00002090| 75 70 20 77 69 6c 6c 20 | 6e 6f 72 6d 61 6c 6c 79 |up will |normally|
|000020a0| 20 6e 6f 74 20 62 65 20 | 6e 65 63 65 73 73 61 72 | not be |necessar|
|000020b0| 79 20 75 6e 6c 65 73 73 | 20 74 68 65 20 73 65 6c |y unless| the sel|
|000020c0| 65 63 74 69 6f 6e 20 63 | 72 69 74 65 72 69 61 20 |ection c|riteria |
|000020d0| 61 72 65 20 76 65 72 79 | 20 63 6f 6d 70 6c 69 63 |are very| complic|
|000020e0| 61 74 65 64 2e 0d 0a 0d | 0a 0d 0a 0d 0d 45 61 63 |ated....|.....Eac|
|000020f0| 68 20 73 65 6c 65 63 74 | 69 6f 6e 20 63 72 69 74 |h select|ion crit|
|00002100| 00 00 00 01 00 00 07 b7 | 54 68 69 73 20 69 73 20 |........|This is |
|00002110| 61 20 63 75 73 74 6f 6d | 20 65 78 70 72 65 73 73 |a custom| express|
|00002120| 69 6f 6e 20 62 75 69 6c | 64 65 72 2e 0d 0a 0d 0a |ion buil|der.....|
|00002130| 41 6e 20 65 78 70 72 65 | 73 73 69 6f 6e 20 69 73 |An expre|ssion is|
|00002140| 20 6f 6e 65 20 6f 72 20 | 6d 6f 72 65 20 73 65 6c | one or |more sel|
|00002150| 65 63 74 69 6f 6e 20 63 | 72 69 74 65 72 69 61 20 |ection c|riteria |
|00002160| 63 6f 6d 62 69 6e 65 64 | 2e 0d 0a 0d 0a 45 61 63 |combined|.....Eac|
|00002170| 68 20 73 65 6c 65 63 74 | 69 6f 6e 20 63 72 69 74 |h select|ion crit|
|00002180| 65 72 69 6f 6e 20 77 69 | 6c 6c 20 62 65 20 63 61 |erion wi|ll be ca|
|00002190| 6c 6c 65 64 20 61 20 70 | 68 72 61 73 65 2e 0d 0a |lled a p|hrase...|
|000021a0| 0d 0a 41 20 70 68 72 61 | 73 65 20 69 73 20 6d 61 |..A phra|se is ma|
|000021b0| 64 65 20 75 70 20 6f 66 | 20 74 68 65 20 66 6f 6c |de up of| the fol|
|000021c0| 6c 6f 77 69 6e 67 3a 0d | 0a 09 31 2e 20 46 49 45 |lowing:.|..1. FIE|
|000021d0| 4c 44 5f 4e 41 4d 45 20 | 20 73 75 63 68 20 61 73 |LD_NAME | such as|
|000021e0| 20 22 4c 41 53 54 5f 4e | 41 4d 45 22 20 20 20 20 | "LAST_N|AME" |
|000021f0| 20 20 20 20 0d 0a 09 32 | 2e 20 4f 50 45 52 41 54 | ...2|. OPERAT|
|00002200| 4f 52 20 20 20 20 73 75 | 63 68 20 61 73 20 22 62 |OR su|ch as "b|
|00002210| 65 67 69 6e 73 20 77 69 | 74 68 22 20 20 0d 0a 09 |egins wi|th" ...|
|00002220| 33 2e 20 44 41 54 41 20 | 20 20 20 20 20 20 20 73 |3. DATA | s|
|00002230| 75 63 68 20 61 73 20 22 | 53 6d 69 74 68 22 20 20 |uch as "|Smith" |
|00002240| 0d 0a 09 0d 0a 09 45 78 | 61 6d 70 6c 65 3a 20 20 |......Ex|ample: |
|00002250| 46 49 45 4c 44 5f 4e 41 | 4d 45 20 20 20 4f 50 45 |FIELD_NA|ME OPE|
|00002260| 52 41 54 4f 52 20 20 20 | 20 44 41 54 41 0d 0a 09 |RATOR | DATA...|
|00002270| 20 20 20 20 20 20 20 20 | 20 20 4c 41 53 54 5f 4e | | LAST_N|
|00002280| 41 4d 45 20 20 20 20 62 | 65 67 69 6e 73 20 77 69 |AME b|egins wi|
|00002290| 74 68 20 22 53 6d 69 74 | 68 22 0d 0a 0d 0a 41 6e |th "Smit|h"....An|
|000022a0| 20 65 78 70 72 65 73 73 | 69 6f 6e 20 6d 61 79 20 | express|ion may |
|000022b0| 68 61 76 65 20 6d 6f 72 | 65 20 74 68 61 6e 20 6f |have mor|e than o|
|000022c0| 6e 65 20 70 68 72 61 73 | 65 2e 20 54 68 69 73 20 |ne phras|e. This |
|000022d0| 61 6c 6c 6f 77 73 20 79 | 6f 75 20 74 6f 20 63 72 |allows y|ou to cr|
|000022e0| 65 61 74 65 0d 0a 73 6f | 6d 65 20 76 65 72 79 20 |eate..so|me very |
|000022f0| 73 6f 70 68 69 73 74 69 | 63 61 74 65 64 20 73 65 |sophisti|cated se|
|00002300| 6c 65 63 74 69 6f 6e 20 | 63 72 69 74 65 72 69 61 |lection |criteria|
|00002310| 2e 0d 0a 0d 0a 50 68 72 | 61 73 65 73 20 61 72 65 |.....Phr|ases are|
|00002320| 20 63 6f 6d 62 69 6e 65 | 64 20 77 69 74 68 20 74 | combine|d with t|
|00002330| 68 65 20 66 6f 6c 6c 6f | 77 69 6e 67 20 43 4f 4e |he follo|wing CON|
|00002340| 4e 45 43 54 4f 52 53 3a | 20 0d 0a 09 31 2e 20 41 |NECTORS:| ...1. A|
|00002350| 4e 44 20 2d 6d 65 61 6e | 73 20 62 6f 74 68 20 70 |ND -mean|s both p|
|00002360| 68 72 61 73 65 73 20 6d | 75 73 74 20 62 65 20 74 |hrases m|ust be t|
|00002370| 72 75 65 20 20 0d 0a 09 | 32 2e 20 4f 52 20 20 2d |rue ...|2. OR -|
|00002380| 6d 65 61 6e 73 20 6f 6e | 65 20 6f 66 20 74 68 65 |means on|e of the|
|00002390| 20 70 68 72 61 73 65 73 | 20 6d 75 73 74 20 62 65 | phrases| must be|
|000023a0| 20 74 72 75 65 20 20 0d | 0a 09 0d 0a 09 45 78 61 | true .|.....Exa|
|000023b0| 6d 70 6c 65 3a 20 20 46 | 49 45 4c 44 5f 4e 41 4d |mple: F|IELD_NAM|
|000023c0| 45 20 20 20 4f 50 45 52 | 41 54 4f 52 20 20 20 20 |E OPER|ATOR |
|000023d0| 20 20 20 20 44 41 54 41 | 20 20 20 20 20 20 43 4f | DATA| CO|
|000023e0| 4e 4e 45 43 54 4f 52 0d | 0a 09 20 20 20 20 20 20 |NNECTOR.|.. |
|000023f0| 20 20 20 20 4c 41 53 54 | 5f 4e 41 4d 45 20 20 20 | LAST|_NAME |
|00002400| 20 62 65 67 69 6e 73 20 | 77 69 74 68 20 20 20 20 | begins |with |
|00002410| 20 22 53 6d 69 74 68 22 | 20 20 20 41 4e 44 0d 0a | "Smith"| AND..|
|00002420| 09 20 20 20 20 20 20 20 | 20 20 20 53 45 58 20 20 |. | SEX |
|00002430| 20 20 20 20 20 20 20 20 | 69 73 20 74 68 65 20 73 | |is the s|
|00002440| 61 6d 65 20 61 73 20 20 | 22 46 45 4d 41 4c 45 22 |ame as |"FEMALE"|
|00002450| 0d 0a 0d 0a 49 6e 20 74 | 68 65 20 61 62 6f 76 65 |....In t|he above|
|00002460| 20 65 78 61 6d 70 6c 65 | 20 74 68 65 20 70 65 72 | example| the per|
|00002470| 73 6f 6e 20 6d 75 73 74 | 20 68 61 76 65 20 61 20 |son must| have a |
|00002480| 6c 61 73 74 20 6e 61 6d | 65 20 74 68 61 74 20 62 |last nam|e that b|
|00002490| 65 67 69 6e 73 20 77 69 | 74 68 0d 0a 22 53 6d 69 |egins wi|th.."Smi|
|000024a0| 74 68 22 20 20 41 4e 44 | 20 20 74 68 65 79 20 6d |th" AND| they m|
|000024b0| 75 73 74 20 62 65 20 61 | 20 66 65 6d 61 6c 65 2e |ust be a| female.|
|000024c0| 0d 0a 49 66 20 74 68 65 | 20 63 6f 6e 6e 65 63 74 |..If the| connect|
|000024d0| 6f 72 20 77 65 72 65 20 | 61 6e 20 22 4f 52 22 20 |or were |an "OR" |
|000024e0| 74 68 65 6e 20 74 68 65 | 20 70 65 72 73 6f 6e 20 |then the| person |
|000024f0| 6d 75 73 74 20 68 61 76 | 65 20 61 20 6c 61 73 74 |must hav|e a last|
|00002500| 20 6e 61 6d 65 20 74 68 | 61 74 20 62 65 67 69 6e | name th|at begin|
|00002510| 73 20 77 69 74 68 20 22 | 53 6d 69 74 68 22 20 20 |s with "|Smith" |
|00002520| 4f 52 20 20 74 68 65 79 | 20 6d 75 73 74 20 62 65 |OR they| must be|
|00002530| 20 61 20 66 65 6d 61 6c | 65 2e 0d 0a 41 20 6c 69 | a femal|e...A li|
|00002540| 73 74 20 6f 66 20 70 65 | 6f 70 6c 65 20 62 61 73 |st of pe|ople bas|
|00002550| 65 64 20 6f 6e 20 74 68 | 65 20 41 4e 44 20 43 4f |ed on th|e AND CO|
|00002560| 4e 4e 45 43 54 4f 52 20 | 77 6f 75 6c 64 20 62 65 |NNECTOR |would be|
|00002570| 20 66 65 6d 61 6c 65 73 | 20 77 68 6f 73 65 20 6c | females| whose l|
|00002580| 61 73 74 0d 0a 6e 61 6d | 65 73 20 62 65 67 69 6e |ast..nam|es begin|
|00002590| 20 77 69 74 68 20 22 53 | 6d 69 74 68 22 2e 0d 0a | with "S|mith"...|
|000025a0| 41 20 6c 69 73 74 20 6f | 66 20 70 65 6f 70 6c 65 |A list o|f people|
|000025b0| 20 62 61 73 65 64 20 6f | 6e 20 74 68 65 20 4f 52 | based o|n the OR|
|000025c0| 20 43 4f 4e 4e 45 43 54 | 4f 52 20 77 6f 75 6c 64 | CONNECT|OR would|
|000025d0| 20 62 65 20 61 6c 6c 20 | 66 65 6d 61 6c 65 73 20 | be all |females |
|000025e0| 6f 72 20 61 6e 79 62 6f | 64 79 20 77 68 6f 73 65 |or anybo|dy whose|
|000025f0| 20 6c 61 73 74 20 6e 61 | 6d 65 73 20 62 65 67 69 | last na|mes begi|
|00002600| 6e 20 77 69 74 68 20 22 | 53 6d 69 74 68 22 28 6d |n with "|Smith"(m|
|00002610| 61 6c 65 20 6f 72 20 66 | 65 6d 61 6c 65 29 2e 0d |ale or f|emale)..|
|00002620| 0a 0d 0a 0d 0a 50 68 72 | 61 73 65 73 20 6d 61 79 |.....Phr|ases may|
|00002630| 20 62 65 20 70 75 74 20 | 69 6e 20 64 69 66 66 65 | be put |in diffe|
|00002640| 72 65 6e 74 20 67 72 6f | 75 70 73 2e 20 54 68 65 |rent gro|ups. The|
|00002650| 20 70 68 72 61 73 65 73 | 20 69 6e 20 74 68 65 20 | phrases| in the |
|00002660| 31 73 74 20 67 72 6f 75 | 70 20 61 72 65 0d 0a 65 |1st grou|p are..e|
|00002670| 76 61 6c 75 61 74 65 64 | 20 61 73 20 61 20 67 72 |valuated| as a gr|
|00002680| 6f 75 70 20 62 65 66 6f | 72 65 20 74 68 65 20 70 |oup befo|re the p|
|00002690| 68 72 61 73 65 73 20 69 | 6e 20 74 68 65 20 32 6e |hrases i|n the 2n|
|000026a0| 64 20 67 72 6f 75 70 20 | 61 72 65 20 65 76 61 6c |d group |are eval|
|000026b0| 75 61 74 65 64 2c 20 61 | 6e 64 20 74 68 65 20 70 |uated, a|nd the p|
|000026c0| 68 72 61 73 65 73 20 69 | 6e 20 74 68 65 20 32 6e |hrases i|n the 2n|
|000026d0| 64 20 67 72 6f 75 70 20 | 61 72 65 20 65 76 61 6c |d group |are eval|
|000026e0| 75 61 74 65 64 20 61 73 | 20 61 20 67 72 6f 75 70 |uated as| a group|
|000026f0| 20 62 65 66 6f 72 65 20 | 74 68 65 20 70 68 72 61 | before |the phra|
|00002700| 73 65 73 20 69 6e 20 74 | 68 65 20 33 72 64 20 67 |ses in t|he 3rd g|
|00002710| 72 6f 75 70 20 61 72 65 | 20 65 76 61 6c 75 61 74 |roup are| evaluat|
|00002720| 65 64 2c 20 65 74 63 2e | 2e 2e 0d 0a 0d 0a 50 75 |ed, etc.|......Pu|
|00002730| 74 74 69 6e 67 20 70 68 | 72 61 73 65 73 20 69 6e |tting ph|rases in|
|00002740| 20 61 20 64 69 66 66 65 | 72 65 6e 74 20 67 72 6f | a diffe|rent gro|
|00002750| 75 70 20 77 69 6c 6c 20 | 6e 6f 72 6d 61 6c 6c 79 |up will |normally|
|00002760| 20 6e 6f 74 20 62 65 20 | 6e 65 63 65 73 73 61 72 | not be |necessar|
|00002770| 79 20 75 6e 6c 65 73 73 | 20 74 68 65 20 73 65 6c |y unless| the sel|
|00002780| 65 63 74 69 6f 6e 20 63 | 72 69 74 65 72 69 61 20 |ection c|riteria |
|00002790| 61 72 65 20 76 65 72 79 | 20 63 6f 6d 70 6c 69 63 |are very| complic|
|000027a0| 61 74 65 64 2e 0d 0a 0d | 0a 0d 0a 09 45 78 61 6d |ated....|....Exam|
|000027b0| 70 6c 65 3a 20 20 46 49 | 45 4c 44 5f 4e 41 4d 45 |ple: FI|ELD_NAME|
|000027c0| 20 20 20 4f 50 45 52 41 | 54 4f 52 20 20 20 20 20 | OPERA|TOR |
|000027d0| 20 20 20 44 41 54 41 20 | 20 20 20 20 20 43 4f 4e | DATA | CON|
|000027e0| 4e 45 43 54 4f 52 20 20 | 47 52 4f 55 50 0d 0a 09 |NECTOR |GROUP...|
|000027f0| 20 20 20 20 20 20 20 20 | 20 20 4c 41 53 54 5f 4e | | LAST_N|
|00002800| 41 4d 45 20 20 20 20 62 | 65 67 69 6e 73 20 77 69 |AME b|egins wi|
|00002810| 74 68 20 20 20 20 20 22 | 53 6d 69 74 68 22 20 20 |th "|Smith" |
|00002820| 20 4f 52 20 20 20 20 20 | 20 20 20 20 31 0d 0a 09 | OR | 1...|
|00002830| 20 20 20 20 20 20 20 20 | 20 20 53 45 58 20 20 20 | | SEX |
|00002840| 20 20 20 20 20 20 20 69 | 73 20 74 68 65 20 73 61 | i|s the sa|
|00002850| 6d 65 20 61 73 20 20 22 | 46 45 4d 41 4c 45 22 20 |me as "|FEMALE" |
|00002860| 20 41 4e 44 20 20 20 20 | 20 20 20 20 31 0d 0a 09 | AND | 1...|
|00002870| 20 20 20 20 20 20 20 20 | 20 20 50 48 4f 4e 45 20 | | PHONE |
|00002880| 20 20 20 20 20 20 20 43 | 4f 4e 54 41 49 4e 53 20 | C|ONTAINS |
|00002890| 20 20 20 20 20 20 20 22 | 31 32 33 22 20 20 20 20 | "|123" |
|000028a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 32 0d 0a 09 | | 2...|
|000028b0| 20 20 20 20 20 20 20 20 | 20 20 20 0d 0a 0d 0a e5 | | .....|
|000028c0| 00 00 00 01 00 00 08 25 | 54 68 69 73 20 69 73 20 |.......%|This is |
|000028d0| 61 20 63 75 73 74 6f 6d | 20 65 78 70 72 65 73 73 |a custom| express|
|000028e0| 69 6f 6e 20 62 75 69 6c | 64 65 72 2e 0d 0a 0d 0a |ion buil|der.....|
|000028f0| 41 6e 20 65 78 70 72 65 | 73 73 69 6f 6e 20 69 73 |An expre|ssion is|
|00002900| 20 6f 6e 65 20 6f 72 20 | 6d 6f 72 65 20 73 65 6c | one or |more sel|
|00002910| 65 63 74 69 6f 6e 20 63 | 72 69 74 65 72 69 61 20 |ection c|riteria |
|00002920| 63 6f 6d 62 69 6e 65 64 | 2e 0d 0a 0d 0a 45 61 63 |combined|.....Eac|
|00002930| 68 20 73 65 6c 65 63 74 | 69 6f 6e 20 63 72 69 74 |h select|ion crit|
|00002940| 65 72 69 6f 6e 20 77 69 | 6c 6c 20 62 65 20 63 61 |erion wi|ll be ca|
|00002950| 6c 6c 65 64 20 61 20 70 | 68 72 61 73 65 2e 0d 0a |lled a p|hrase...|
|00002960| 0d 0a 41 20 70 68 72 61 | 73 65 20 69 73 20 6d 61 |..A phra|se is ma|
|00002970| 64 65 20 75 70 20 6f 66 | 20 74 68 65 20 66 6f 6c |de up of| the fol|
|00002980| 6c 6f 77 69 6e 67 3a 0d | 0a 09 31 2e 20 46 49 45 |lowing:.|..1. FIE|
|00002990| 4c 44 5f 4e 41 4d 45 20 | 20 73 75 63 68 20 61 73 |LD_NAME | such as|
|000029a0| 20 22 4c 41 53 54 5f 4e | 41 4d 45 22 20 20 20 20 | "LAST_N|AME" |
|000029b0| 20 20 20 20 0d 0a 09 32 | 2e 20 4f 50 45 52 41 54 | ...2|. OPERAT|
|000029c0| 4f 52 20 20 20 20 73 75 | 63 68 20 61 73 20 22 62 |OR su|ch as "b|
|000029d0| 65 67 69 6e 73 20 77 69 | 74 68 22 20 20 0d 0a 09 |egins wi|th" ...|
|000029e0| 33 2e 20 44 41 54 41 20 | 20 20 20 20 20 20 20 73 |3. DATA | s|
|000029f0| 75 63 68 20 61 73 20 22 | 53 6d 69 74 68 22 20 20 |uch as "|Smith" |
|00002a00| 0d 0a 09 0d 0a 09 45 78 | 61 6d 70 6c 65 3a 20 20 |......Ex|ample: |
|00002a10| 46 49 45 4c 44 5f 4e 41 | 4d 45 20 20 20 4f 50 45 |FIELD_NA|ME OPE|
|00002a20| 52 41 54 4f 52 20 20 20 | 20 44 41 54 41 0d 0a 09 |RATOR | DATA...|
|00002a30| 20 20 20 20 20 20 20 20 | 20 20 4c 41 53 54 5f 4e | | LAST_N|
|00002a40| 41 4d 45 20 20 20 20 62 | 65 67 69 6e 73 20 77 69 |AME b|egins wi|
|00002a50| 74 68 20 22 53 6d 69 74 | 68 22 0d 0a 0d 0a 41 6e |th "Smit|h"....An|
|00002a60| 20 65 78 70 72 65 73 73 | 69 6f 6e 20 6d 61 79 20 | express|ion may |
|00002a70| 68 61 76 65 20 6d 6f 72 | 65 20 74 68 61 6e 20 6f |have mor|e than o|
|00002a80| 6e 65 20 70 68 72 61 73 | 65 2e 20 54 68 69 73 20 |ne phras|e. This |
|00002a90| 61 6c 6c 6f 77 73 20 79 | 6f 75 20 74 6f 20 63 72 |allows y|ou to cr|
|00002aa0| 65 61 74 65 0d 0a 73 6f | 6d 65 20 76 65 72 79 20 |eate..so|me very |
|00002ab0| 73 6f 70 68 69 73 74 69 | 63 61 74 65 64 20 73 65 |sophisti|cated se|
|00002ac0| 6c 65 63 74 69 6f 6e 20 | 63 72 69 74 65 72 69 61 |lection |criteria|
|00002ad0| 2e 0d 0a 0d 0a 50 68 72 | 61 73 65 73 20 61 72 65 |.....Phr|ases are|
|00002ae0| 20 63 6f 6d 62 69 6e 65 | 64 20 77 69 74 68 20 74 | combine|d with t|
|00002af0| 68 65 20 66 6f 6c 6c 6f | 77 69 6e 67 20 43 4f 4e |he follo|wing CON|
|00002b00| 4e 45 43 54 4f 52 53 3a | 20 0d 0a 09 31 2e 20 41 |NECTORS:| ...1. A|
|00002b10| 4e 44 20 2d 6d 65 61 6e | 73 20 62 6f 74 68 20 70 |ND -mean|s both p|
|00002b20| 68 72 61 73 65 73 20 6d | 75 73 74 20 62 65 20 74 |hrases m|ust be t|
|00002b30| 72 75 65 20 20 0d 0a 09 | 32 2e 20 4f 52 20 20 2d |rue ...|2. OR -|
|00002b40| 6d 65 61 6e 73 20 6f 6e | 65 20 6f 66 20 74 68 65 |means on|e of the|
|00002b50| 20 70 68 72 61 73 65 73 | 20 6d 75 73 74 20 62 65 | phrases| must be|
|00002b60| 20 74 72 75 65 20 20 0d | 0a 09 0d 0a 09 45 78 61 | true .|.....Exa|
|00002b70| 6d 70 6c 65 3a 20 20 46 | 49 45 4c 44 5f 4e 41 4d |mple: F|IELD_NAM|
|00002b80| 45 20 20 20 4f 50 45 52 | 41 54 4f 52 20 20 20 20 |E OPER|ATOR |
|00002b90| 20 20 20 20 44 41 54 41 | 20 20 20 20 20 20 43 4f | DATA| CO|
|00002ba0| 4e 4e 45 43 54 4f 52 0d | 0a 09 20 20 20 20 20 20 |NNECTOR.|.. |
|00002bb0| 20 20 20 20 4c 41 53 54 | 5f 4e 41 4d 45 20 20 20 | LAST|_NAME |
|00002bc0| 20 62 65 67 69 6e 73 20 | 77 69 74 68 20 20 20 20 | begins |with |
|00002bd0| 20 22 53 6d 69 74 68 22 | 20 20 20 41 4e 44 0d 0a | "Smith"| AND..|
|00002be0| 09 20 20 20 20 20 20 20 | 20 20 20 53 45 58 20 20 |. | SEX |
|00002bf0| 20 20 20 20 20 20 20 20 | 69 73 20 74 68 65 20 73 | |is the s|
|00002c00| 61 6d 65 20 61 73 20 20 | 22 46 45 4d 41 4c 45 22 |ame as |"FEMALE"|
|00002c10| 0d 0a 0d 0a 49 6e 20 74 | 68 65 20 61 62 6f 76 65 |....In t|he above|
|00002c20| 20 65 78 61 6d 70 6c 65 | 20 74 68 65 20 70 65 72 | example| the per|
|00002c30| 73 6f 6e 20 6d 75 73 74 | 20 68 61 76 65 20 61 20 |son must| have a |
|00002c40| 6c 61 73 74 20 6e 61 6d | 65 20 74 68 61 74 20 62 |last nam|e that b|
|00002c50| 65 67 69 6e 73 20 77 69 | 74 68 0d 0a 22 53 6d 69 |egins wi|th.."Smi|
|00002c60| 74 68 22 20 20 41 4e 44 | 20 20 74 68 65 79 20 6d |th" AND| they m|
|00002c70| 75 73 74 20 62 65 20 61 | 20 66 65 6d 61 6c 65 2e |ust be a| female.|
|00002c80| 0d 0a 49 66 20 74 68 65 | 20 63 6f 6e 6e 65 63 74 |..If the| connect|
|00002c90| 6f 72 20 77 65 72 65 20 | 61 6e 20 22 4f 52 22 20 |or were |an "OR" |
|00002ca0| 74 68 65 6e 20 74 68 65 | 20 70 65 72 73 6f 6e 20 |then the| person |
|00002cb0| 6d 75 73 74 20 68 61 76 | 65 20 61 20 6c 61 73 74 |must hav|e a last|
|00002cc0| 20 6e 61 6d 65 20 74 68 | 61 74 20 62 65 67 69 6e | name th|at begin|
|00002cd0| 73 20 77 69 74 68 20 22 | 53 6d 69 74 68 22 20 20 |s with "|Smith" |
|00002ce0| 4f 52 20 20 74 68 65 79 | 20 6d 75 73 74 20 62 65 |OR they| must be|
|00002cf0| 20 61 20 66 65 6d 61 6c | 65 2e 0d 0a 41 20 6c 69 | a femal|e...A li|
|00002d00| 73 74 20 6f 66 20 70 65 | 6f 70 6c 65 20 62 61 73 |st of pe|ople bas|
|00002d10| 65 64 20 6f 6e 20 74 68 | 65 20 41 4e 44 20 43 4f |ed on th|e AND CO|
|00002d20| 4e 4e 45 43 54 4f 52 20 | 77 6f 75 6c 64 20 62 65 |NNECTOR |would be|
|00002d30| 20 66 65 6d 61 6c 65 73 | 20 77 68 6f 73 65 20 6c | females| whose l|
|00002d40| 61 73 74 0d 0a 6e 61 6d | 65 73 20 62 65 67 69 6e |ast..nam|es begin|
|00002d50| 20 77 69 74 68 20 22 53 | 6d 69 74 68 22 2e 0d 0a | with "S|mith"...|
|00002d60| 41 20 6c 69 73 74 20 6f | 66 20 70 65 6f 70 6c 65 |A list o|f people|
|00002d70| 20 62 61 73 65 64 20 6f | 6e 20 74 68 65 20 4f 52 | based o|n the OR|
|00002d80| 20 43 4f 4e 4e 45 43 54 | 4f 52 20 77 6f 75 6c 64 | CONNECT|OR would|
|00002d90| 20 62 65 20 61 6c 6c 20 | 66 65 6d 61 6c 65 73 20 | be all |females |
|00002da0| 6f 72 20 61 6e 79 62 6f | 64 79 20 77 68 6f 73 65 |or anybo|dy whose|
|00002db0| 20 6c 61 73 74 20 6e 61 | 6d 65 73 20 62 65 67 69 | last na|mes begi|
|00002dc0| 6e 20 77 69 74 68 20 22 | 53 6d 69 74 68 22 28 6d |n with "|Smith"(m|
|00002dd0| 61 6c 65 20 6f 72 20 66 | 65 6d 61 6c 65 29 2e 0d |ale or f|emale)..|
|00002de0| 0a 0d 0a 0d 0a 50 68 72 | 61 73 65 73 20 6d 61 79 |.....Phr|ases may|
|00002df0| 20 62 65 20 70 75 74 20 | 69 6e 20 64 69 66 66 65 | be put |in diffe|
|00002e00| 72 65 6e 74 20 67 72 6f | 75 70 73 2e 20 54 68 65 |rent gro|ups. The|
|00002e10| 20 70 68 72 61 73 65 73 | 20 69 6e 20 74 68 65 20 | phrases| in the |
|00002e20| 31 73 74 20 67 72 6f 75 | 70 20 61 72 65 0d 0a 65 |1st grou|p are..e|
|00002e30| 76 61 6c 75 61 74 65 64 | 20 61 73 20 61 20 67 72 |valuated| as a gr|
|00002e40| 6f 75 70 20 62 65 66 6f | 72 65 20 74 68 65 20 70 |oup befo|re the p|
|00002e50| 68 72 61 73 65 73 20 69 | 6e 20 74 68 65 20 32 6e |hrases i|n the 2n|
|00002e60| 64 20 67 72 6f 75 70 20 | 61 72 65 20 65 76 61 6c |d group |are eval|
|00002e70| 75 61 74 65 64 2c 20 61 | 6e 64 20 74 68 65 20 70 |uated, a|nd the p|
|00002e80| 68 72 61 73 65 73 20 69 | 6e 20 74 68 65 20 32 6e |hrases i|n the 2n|
|00002e90| 64 20 67 72 6f 75 70 20 | 61 72 65 20 65 76 61 6c |d group |are eval|
|00002ea0| 75 61 74 65 64 20 61 73 | 20 61 20 67 72 6f 75 70 |uated as| a group|
|00002eb0| 20 62 65 66 6f 72 65 20 | 74 68 65 20 70 68 72 61 | before |the phra|
|00002ec0| 73 65 73 20 69 6e 20 74 | 68 65 20 33 72 64 20 67 |ses in t|he 3rd g|
|00002ed0| 72 6f 75 70 20 61 72 65 | 20 65 76 61 6c 75 61 74 |roup are| evaluat|
|00002ee0| 65 64 2c 20 65 74 63 2e | 2e 2e 0d 0a 0d 0a 50 75 |ed, etc.|......Pu|
|00002ef0| 74 74 69 6e 67 20 70 68 | 72 61 73 65 73 20 69 6e |tting ph|rases in|
|00002f00| 20 61 20 64 69 66 66 65 | 72 65 6e 74 20 67 72 6f | a diffe|rent gro|
|00002f10| 75 70 20 77 69 6c 6c 20 | 6e 6f 72 6d 61 6c 6c 79 |up will |normally|
|00002f20| 20 6e 6f 74 20 62 65 20 | 6e 65 63 65 73 73 61 72 | not be |necessar|
|00002f30| 79 20 75 6e 6c 65 73 73 | 20 74 68 65 20 73 65 6c |y unless| the sel|
|00002f40| 65 63 74 69 6f 6e 20 63 | 72 69 74 65 72 69 61 20 |ection c|riteria |
|00002f50| 61 72 65 20 76 65 72 79 | 20 63 6f 6d 70 6c 69 63 |are very| complic|
|00002f60| 61 74 65 64 2e 0d 0a 0d | 0a 0d 0a 09 45 78 61 6d |ated....|....Exam|
|00002f70| 70 6c 65 3a 20 20 46 49 | 45 4c 44 5f 4e 41 4d 45 |ple: FI|ELD_NAME|
|00002f80| 20 20 20 4f 50 45 52 41 | 54 4f 52 20 20 20 20 20 | OPERA|TOR |
|00002f90| 20 20 20 44 41 54 41 20 | 20 20 20 20 20 43 4f 4e | DATA | CON|
|00002fa0| 4e 45 43 54 4f 52 20 20 | 47 52 4f 55 50 0d 0a 09 |NECTOR |GROUP...|
|00002fb0| 20 20 20 20 20 20 20 20 | 20 20 4c 41 53 54 5f 4e | | LAST_N|
|00002fc0| 41 4d 45 20 20 20 20 62 | 65 67 69 6e 73 20 77 69 |AME b|egins wi|
|00002fd0| 74 68 20 20 20 20 20 22 | 53 6d 69 74 68 22 20 20 |th "|Smith" |
|00002fe0| 20 4f 52 20 20 20 20 20 | 20 20 20 20 31 0d 0a 09 | OR | 1...|
|00002ff0| 20 20 20 20 20 20 20 20 | 20 20 53 45 58 20 20 20 | | SEX |
|00003000| 20 20 20 20 20 20 20 69 | 73 20 74 68 65 20 73 61 | i|s the sa|
|00003010| 6d 65 20 61 73 20 20 22 | 46 45 4d 41 4c 45 22 20 |me as "|FEMALE" |
|00003020| 20 41 4e 44 20 20 20 20 | 20 20 20 20 31 0d 0a 09 | AND | 1...|
|00003030| 20 20 20 20 20 20 20 20 | 20 20 50 48 4f 4e 45 20 | | PHONE |
|00003040| 20 20 20 20 20 20 20 43 | 4f 4e 54 41 49 4e 53 20 | C|ONTAINS |
|00003050| 20 20 20 20 20 20 20 22 | 31 32 33 22 20 20 20 20 | "|123" |
|00003060| 20 20 20 20 20 20 20 20 | 20 20 20 20 32 0d 0a 09 | | 2...|
|00003070| 20 20 20 20 20 20 20 20 | 20 20 20 0d 0a 0d 0a 49 | | ....I|
|00003080| 6e 20 74 68 65 20 61 62 | 6f 76 65 20 65 78 61 6d |n the ab|ove exam|
|00003090| 70 6c 65 20 74 68 65 20 | 70 65 72 73 6f 6e 20 6d |ple the |person m|
|000030a0| 75 73 74 20 68 61 76 65 | 20 61 20 6c 61 73 74 20 |ust have| a last |
|000030b0| 6e 61 6d 65 20 74 68 61 | 74 20 62 65 67 69 6e 73 |name tha|t begins|
|000030c0| 20 77 69 74 68 0d 0a 22 | 53 6d 69 74 68 22 20 20 | with.."|Smith" |
|000030d0| 41 4e 44 20 20 74 68 65 | 79 20 6d 75 73 74 20 62 |AND the|y must b|
|000030e0| 65 20 61 20 66 65 6d 61 | 6c 65 2e 0d 0a 7e e0 00 |e a fema|le...~..|
|000030f0| 75 61 8b 5e ea 3b 5e fc | 77 59 80 3e cc 38 00 74 |ua.^.;^.|wY.>.8.t|
|00003100| 00 00 00 01 00 00 09 47 | 54 68 69 73 20 69 73 20 |.......G|This is |
|00003110| 61 20 63 75 73 74 6f 6d | 20 65 78 70 72 65 73 73 |a custom| express|
|00003120| 69 6f 6e 20 62 75 69 6c | 64 65 72 2e 0d 0a 0d 0a |ion buil|der.....|
|00003130| 41 6e 20 65 78 70 72 65 | 73 73 69 6f 6e 20 69 73 |An expre|ssion is|
|00003140| 20 6f 6e 65 20 6f 72 20 | 6d 6f 72 65 20 73 65 6c | one or |more sel|
|00003150| 65 63 74 69 6f 6e 20 63 | 72 69 74 65 72 69 61 20 |ection c|riteria |
|00003160| 63 6f 6d 62 69 6e 65 64 | 2e 0d 0a 0d 0a 45 61 63 |combined|.....Eac|
|00003170| 68 20 73 65 6c 65 63 74 | 69 6f 6e 20 63 72 69 74 |h select|ion crit|
|00003180| 65 72 69 6f 6e 20 77 69 | 6c 6c 20 62 65 20 63 61 |erion wi|ll be ca|
|00003190| 6c 6c 65 64 20 61 20 70 | 68 72 61 73 65 2e 0d 0a |lled a p|hrase...|
|000031a0| 0d 0a 41 20 70 68 72 61 | 73 65 20 69 73 20 6d 61 |..A phra|se is ma|
|000031b0| 64 65 20 75 70 20 6f 66 | 20 74 68 65 20 66 6f 6c |de up of| the fol|
|000031c0| 6c 6f 77 69 6e 67 3a 0d | 0a 09 31 2e 20 46 49 45 |lowing:.|..1. FIE|
|000031d0| 4c 44 5f 4e 41 4d 45 20 | 20 73 75 63 68 20 61 73 |LD_NAME | such as|
|000031e0| 20 22 4c 41 53 54 5f 4e | 41 4d 45 22 20 20 20 20 | "LAST_N|AME" |
|000031f0| 20 20 20 20 0d 0a 09 32 | 2e 20 4f 50 45 52 41 54 | ...2|. OPERAT|
|00003200| 4f 52 20 20 20 20 73 75 | 63 68 20 61 73 20 22 62 |OR su|ch as "b|
|00003210| 65 67 69 6e 73 20 77 69 | 74 68 22 20 20 0d 0a 09 |egins wi|th" ...|
|00003220| 33 2e 20 44 41 54 41 20 | 20 20 20 20 20 20 20 73 |3. DATA | s|
|00003230| 75 63 68 20 61 73 20 22 | 53 6d 69 74 68 22 20 20 |uch as "|Smith" |
|00003240| 0d 0a 09 0d 0a 09 45 78 | 61 6d 70 6c 65 3a 20 20 |......Ex|ample: |
|00003250| 46 49 45 4c 44 5f 4e 41 | 4d 45 20 20 20 4f 50 45 |FIELD_NA|ME OPE|
|00003260| 52 41 54 4f 52 20 20 20 | 20 44 41 54 41 0d 0a 09 |RATOR | DATA...|
|00003270| 20 20 20 20 20 20 20 20 | 20 20 4c 41 53 54 5f 4e | | LAST_N|
|00003280| 41 4d 45 20 20 20 20 62 | 65 67 69 6e 73 20 77 69 |AME b|egins wi|
|00003290| 74 68 20 22 53 6d 69 74 | 68 22 0d 0a 0d 0a 41 6e |th "Smit|h"....An|
|000032a0| 20 65 78 70 72 65 73 73 | 69 6f 6e 20 6d 61 79 20 | express|ion may |
|000032b0| 68 61 76 65 20 6d 6f 72 | 65 20 74 68 61 6e 20 6f |have mor|e than o|
|000032c0| 6e 65 20 70 68 72 61 73 | 65 2e 20 54 68 69 73 20 |ne phras|e. This |
|000032d0| 61 6c 6c 6f 77 73 20 79 | 6f 75 20 74 6f 20 63 72 |allows y|ou to cr|
|000032e0| 65 61 74 65 0d 0a 73 6f | 6d 65 20 76 65 72 79 20 |eate..so|me very |
|000032f0| 73 6f 70 68 69 73 74 69 | 63 61 74 65 64 20 73 65 |sophisti|cated se|
|00003300| 6c 65 63 74 69 6f 6e 20 | 63 72 69 74 65 72 69 61 |lection |criteria|
|00003310| 2e 0d 0a 0d 0a 50 68 72 | 61 73 65 73 20 61 72 65 |.....Phr|ases are|
|00003320| 20 63 6f 6d 62 69 6e 65 | 64 20 77 69 74 68 20 74 | combine|d with t|
|00003330| 68 65 20 66 6f 6c 6c 6f | 77 69 6e 67 20 43 4f 4e |he follo|wing CON|
|00003340| 4e 45 43 54 4f 52 53 3a | 20 0d 0a 09 31 2e 20 41 |NECTORS:| ...1. A|
|00003350| 4e 44 20 2d 6d 65 61 6e | 73 20 62 6f 74 68 20 70 |ND -mean|s both p|
|00003360| 68 72 61 73 65 73 20 6d | 75 73 74 20 62 65 20 74 |hrases m|ust be t|
|00003370| 72 75 65 20 20 0d 0a 09 | 32 2e 20 4f 52 20 20 2d |rue ...|2. OR -|
|00003380| 6d 65 61 6e 73 20 6f 6e | 65 20 6f 66 20 74 68 65 |means on|e of the|
|00003390| 20 70 68 72 61 73 65 73 | 20 6d 75 73 74 20 62 65 | phrases| must be|
|000033a0| 20 74 72 75 65 20 20 0d | 0a 09 0d 0a 09 45 78 61 | true .|.....Exa|
|000033b0| 6d 70 6c 65 3a 20 20 46 | 49 45 4c 44 5f 4e 41 4d |mple: F|IELD_NAM|
|000033c0| 45 20 20 20 4f 50 45 52 | 41 54 4f 52 20 20 20 20 |E OPER|ATOR |
|000033d0| 20 20 20 20 44 41 54 41 | 20 20 20 20 20 20 43 4f | DATA| CO|
|000033e0| 4e 4e 45 43 54 4f 52 0d | 0a 09 20 20 20 20 20 20 |NNECTOR.|.. |
|000033f0| 20 20 20 20 4c 41 53 54 | 5f 4e 41 4d 45 20 20 20 | LAST|_NAME |
|00003400| 20 62 65 67 69 6e 73 20 | 77 69 74 68 20 20 20 20 | begins |with |
|00003410| 20 22 53 6d 69 74 68 22 | 20 20 20 41 4e 44 0d 0a | "Smith"| AND..|
|00003420| 09 20 20 20 20 20 20 20 | 20 20 20 53 45 58 20 20 |. | SEX |
|00003430| 20 20 20 20 20 20 20 20 | 69 73 20 74 68 65 20 73 | |is the s|
|00003440| 61 6d 65 20 61 73 20 20 | 22 46 45 4d 41 4c 45 22 |ame as |"FEMALE"|
|00003450| 0d 0a 0d 0a 49 6e 20 74 | 68 65 20 61 62 6f 76 65 |....In t|he above|
|00003460| 20 65 78 61 6d 70 6c 65 | 20 74 68 65 20 70 65 72 | example| the per|
|00003470| 73 6f 6e 20 6d 75 73 74 | 20 68 61 76 65 20 61 20 |son must| have a |
|00003480| 6c 61 73 74 20 6e 61 6d | 65 20 74 68 61 74 20 62 |last nam|e that b|
|00003490| 65 67 69 6e 73 20 77 69 | 74 68 0d 0a 22 53 6d 69 |egins wi|th.."Smi|
|000034a0| 74 68 22 20 20 41 4e 44 | 20 20 74 68 65 79 20 6d |th" AND| they m|
|000034b0| 75 73 74 20 62 65 20 61 | 20 66 65 6d 61 6c 65 2e |ust be a| female.|
|000034c0| 0d 0a 49 66 20 74 68 65 | 20 63 6f 6e 6e 65 63 74 |..If the| connect|
|000034d0| 6f 72 20 77 65 72 65 20 | 61 6e 20 22 4f 52 22 20 |or were |an "OR" |
|000034e0| 74 68 65 6e 20 74 68 65 | 20 70 65 72 73 6f 6e 20 |then the| person |
|000034f0| 6d 75 73 74 20 68 61 76 | 65 20 61 20 6c 61 73 74 |must hav|e a last|
|00003500| 20 6e 61 6d 65 20 74 68 | 61 74 20 62 65 67 69 6e | name th|at begin|
|00003510| 73 20 77 69 74 68 20 22 | 53 6d 69 74 68 22 20 20 |s with "|Smith" |
|00003520| 4f 52 20 20 74 68 65 79 | 20 6d 75 73 74 20 62 65 |OR they| must be|
|00003530| 20 61 20 66 65 6d 61 6c | 65 2e 0d 0a 41 20 6c 69 | a femal|e...A li|
|00003540| 73 74 20 6f 66 20 70 65 | 6f 70 6c 65 20 62 61 73 |st of pe|ople bas|
|00003550| 65 64 20 6f 6e 20 74 68 | 65 20 41 4e 44 20 43 4f |ed on th|e AND CO|
|00003560| 4e 4e 45 43 54 4f 52 20 | 77 6f 75 6c 64 20 62 65 |NNECTOR |would be|
|00003570| 20 66 65 6d 61 6c 65 73 | 20 77 68 6f 73 65 20 6c | females| whose l|
|00003580| 61 73 74 0d 0a 6e 61 6d | 65 73 20 62 65 67 69 6e |ast..nam|es begin|
|00003590| 20 77 69 74 68 20 22 53 | 6d 69 74 68 22 2e 0d 0a | with "S|mith"...|
|000035a0| 41 20 6c 69 73 74 20 6f | 66 20 70 65 6f 70 6c 65 |A list o|f people|
|000035b0| 20 62 61 73 65 64 20 6f | 6e 20 74 68 65 20 4f 52 | based o|n the OR|
|000035c0| 20 43 4f 4e 4e 45 43 54 | 4f 52 20 77 6f 75 6c 64 | CONNECT|OR would|
|000035d0| 20 62 65 20 61 6c 6c 20 | 66 65 6d 61 6c 65 73 20 | be all |females |
|000035e0| 6f 72 20 61 6e 79 62 6f | 64 79 20 77 68 6f 73 65 |or anybo|dy whose|
|000035f0| 20 6c 61 73 74 20 6e 61 | 6d 65 73 20 62 65 67 69 | last na|mes begi|
|00003600| 6e 20 77 69 74 68 20 22 | 53 6d 69 74 68 22 28 6d |n with "|Smith"(m|
|00003610| 61 6c 65 20 6f 72 20 66 | 65 6d 61 6c 65 29 2e 0d |ale or f|emale)..|
|00003620| 0a 0d 0a 0d 0a 50 68 72 | 61 73 65 73 20 6d 61 79 |.....Phr|ases may|
|00003630| 20 62 65 20 70 75 74 20 | 69 6e 20 64 69 66 66 65 | be put |in diffe|
|00003640| 72 65 6e 74 20 67 72 6f | 75 70 73 2e 20 54 68 65 |rent gro|ups. The|
|00003650| 20 70 68 72 61 73 65 73 | 20 69 6e 20 74 68 65 20 | phrases| in the |
|00003660| 31 73 74 20 67 72 6f 75 | 70 20 61 72 65 0d 0a 65 |1st grou|p are..e|
|00003670| 76 61 6c 75 61 74 65 64 | 20 61 73 20 61 20 67 72 |valuated| as a gr|
|00003680| 6f 75 70 20 62 65 66 6f | 72 65 20 74 68 65 20 70 |oup befo|re the p|
|00003690| 68 72 61 73 65 73 20 69 | 6e 20 74 68 65 20 32 6e |hrases i|n the 2n|
|000036a0| 64 20 67 72 6f 75 70 20 | 61 72 65 20 65 76 61 6c |d group |are eval|
|000036b0| 75 61 74 65 64 2c 20 61 | 6e 64 20 74 68 65 20 70 |uated, a|nd the p|
|000036c0| 68 72 61 73 65 73 20 69 | 6e 20 74 68 65 20 32 6e |hrases i|n the 2n|
|000036d0| 64 20 67 72 6f 75 70 20 | 61 72 65 20 65 76 61 6c |d group |are eval|
|000036e0| 75 61 74 65 64 20 61 73 | 20 61 20 67 72 6f 75 70 |uated as| a group|
|000036f0| 20 62 65 66 6f 72 65 20 | 74 68 65 20 70 68 72 61 | before |the phra|
|00003700| 73 65 73 20 69 6e 20 74 | 68 65 20 33 72 64 20 67 |ses in t|he 3rd g|
|00003710| 72 6f 75 70 20 61 72 65 | 20 65 76 61 6c 75 61 74 |roup are| evaluat|
|00003720| 65 64 2c 20 65 74 63 2e | 2e 2e 0d 0a 0d 0a 50 75 |ed, etc.|......Pu|
|00003730| 74 74 69 6e 67 20 70 68 | 72 61 73 65 73 20 69 6e |tting ph|rases in|
|00003740| 20 61 20 64 69 66 66 65 | 72 65 6e 74 20 67 72 6f | a diffe|rent gro|
|00003750| 75 70 20 77 69 6c 6c 20 | 6e 6f 72 6d 61 6c 6c 79 |up will |normally|
|00003760| 20 6e 6f 74 20 62 65 20 | 6e 65 63 65 73 73 61 72 | not be |necessar|
|00003770| 79 20 75 6e 6c 65 73 73 | 20 74 68 65 20 73 65 6c |y unless| the sel|
|00003780| 65 63 74 69 6f 6e 20 63 | 72 69 74 65 72 69 61 20 |ection c|riteria |
|00003790| 61 72 65 20 76 65 72 79 | 20 63 6f 6d 70 6c 69 63 |are very| complic|
|000037a0| 61 74 65 64 2e 0d 0a 0d | 0a 0d 0a 09 45 78 61 6d |ated....|....Exam|
|000037b0| 70 6c 65 3a 20 20 46 49 | 45 4c 44 5f 4e 41 4d 45 |ple: FI|ELD_NAME|
|000037c0| 20 20 20 4f 50 45 52 41 | 54 4f 52 20 20 20 20 20 | OPERA|TOR |
|000037d0| 20 20 20 44 41 54 41 20 | 20 20 20 20 20 43 4f 4e | DATA | CON|
|000037e0| 4e 45 43 54 4f 52 20 20 | 47 52 4f 55 50 0d 0a 09 |NECTOR |GROUP...|
|000037f0| 20 20 20 20 20 20 20 20 | 20 20 4c 41 53 54 5f 4e | | LAST_N|
|00003800| 41 4d 45 20 20 20 20 62 | 65 67 69 6e 73 20 77 69 |AME b|egins wi|
|00003810| 74 68 20 20 20 20 20 22 | 53 6d 69 74 68 22 20 20 |th "|Smith" |
|00003820| 20 4f 52 20 20 20 20 20 | 20 20 20 20 31 0d 0a 09 | OR | 1...|
|00003830| 20 20 20 20 20 20 20 20 | 20 20 53 45 58 20 20 20 | | SEX |
|00003840| 20 20 20 20 20 20 20 69 | 73 20 74 68 65 20 73 61 | i|s the sa|
|00003850| 6d 65 20 61 73 20 20 22 | 46 45 4d 41 4c 45 22 20 |me as "|FEMALE" |
|00003860| 20 41 4e 44 20 20 20 20 | 20 20 20 20 31 0d 0a 09 | AND | 1...|
|00003870| 20 20 20 20 20 20 20 20 | 20 20 50 48 4f 4e 45 20 | | PHONE |
|00003880| 20 20 20 20 20 20 20 43 | 4f 4e 54 41 49 4e 53 20 | C|ONTAINS |
|00003890| 20 20 20 20 20 20 20 22 | 31 32 33 22 20 20 20 20 | "|123" |
|000038a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 32 0d 0a 09 | | 2...|
|000038b0| 20 20 20 20 20 20 20 20 | 20 20 20 0d 0a 0d 0a 49 | | ....I|
|000038c0| 6e 20 74 68 65 20 61 62 | 6f 76 65 20 65 78 61 6d |n the ab|ove exam|
|000038d0| 70 6c 65 20 74 68 65 20 | 70 65 72 73 6f 6e 20 6d |ple the |person m|
|000038e0| 75 73 74 20 68 61 76 65 | 20 61 20 6c 61 73 74 20 |ust have| a last |
|000038f0| 6e 61 6d 65 20 74 68 61 | 74 20 62 65 67 69 6e 73 |name tha|t begins|
|00003900| 20 77 69 74 68 0d 0a 22 | 53 6d 69 74 68 22 20 20 | with.."|Smith" |
|00003910| 4f 52 20 20 74 68 65 79 | 20 6d 75 73 74 20 62 65 |OR they| must be|
|00003920| 20 61 20 66 65 6d 61 6c | 65 2e 20 0d 0a 41 6e 79 | a femal|e. ..Any|
|00003930| 6f 6e 65 20 6d 61 74 63 | 68 69 6e 67 20 74 68 65 |one matc|hing the|
|00003940| 20 61 62 6f 76 65 20 63 | 72 69 74 65 72 69 61 20 | above c|riteria |
|00003950| 6d 75 73 74 20 61 6c 73 | 6f 20 68 61 76 65 20 61 |must als|o have a|
|00003960| 20 70 68 6f 6e 65 20 6e | 75 6d 62 65 72 20 74 68 | phone n|umber th|
|00003970| 61 74 0d 0a 63 6f 6e 74 | 61 69 6e 73 20 22 31 32 |at..cont|ains "12|
|00003980| 33 22 2e 0d 0a 49 74 20 | 77 6f 75 6c 64 20 6c 69 |3"...It |would li|
|00003990| 73 74 20 72 65 63 6f 72 | 64 73 20 6c 69 6b 65 3a |st recor|ds like:|
|000039a0| 0d 0a 09 4e 61 6d 65 20 | 20 20 20 20 20 20 20 20 |...Name | |
|000039b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 53 65 78 20 | | Sex |
|000039c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000039d0| 20 50 68 6f 6e 65 0d 0a | 09 42 69 6c 6c 20 53 6d | Phone..|.Bill Sm|
|000039e0| 69 74 68 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |ith | |
|000039f0| 20 20 4d 61 6c 65 20 20 | 20 20 20 20 20 20 20 20 | Male | |
|00003a00| 20 20 20 20 20 20 20 34 | 34 34 2d 31 32 33 34 0d | 4|44-1234.|
|00003a10| 0a 09 4a 61 6e 65 20 44 | 6f 65 20 20 20 20 20 20 |..Jane D|oe |
|00003a20| 20 20 20 20 20 20 20 20 | 20 20 20 46 65 6d 61 6c | | Femal|
|00003a30| 65 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |e | |
|00003a40| 31 32 33 2d 34 34 34 34 | 20 0d 0a 09 20 0d 0a 64 |123-4444| ... ..d|
|00003a50| 2e 0d 0a 0d 0a 54 68 65 | 20 54 49 4d 45 4f 55 54 |.....The| TIMEOUT|
|00003a60| 20 63 6c 61 75 73 65 20 | 69 73 20 65 66 66 65 63 | clause |is effec|
|00003a70| 74 69 76 65 20 6f 6e 6c | 79 20 77 69 74 68 69 6e |tive onl|y within|
|00003a80| 00 00 00 01 00 00 0a 6f | 54 68 69 73 20 69 73 20 |.......o|This is |
|00003a90| 61 20 63 75 73 74 6f 6d | 20 65 78 70 72 65 73 73 |a custom| express|
|00003aa0| 69 6f 6e 20 62 75 69 6c | 64 65 72 2e 0d 0a 0d 0a |ion buil|der.....|
|00003ab0| 41 6e 20 65 78 70 72 65 | 73 73 69 6f 6e 20 69 73 |An expre|ssion is|
|00003ac0| 20 6f 6e 65 20 6f 72 20 | 6d 6f 72 65 20 73 65 6c | one or |more sel|
|00003ad0| 65 63 74 69 6f 6e 20 63 | 72 69 74 65 72 69 61 20 |ection c|riteria |
|00003ae0| 63 6f 6d 62 69 6e 65 64 | 2e 0d 0a 0d 0a 45 61 63 |combined|.....Eac|
|00003af0| 68 20 73 65 6c 65 63 74 | 69 6f 6e 20 63 72 69 74 |h select|ion crit|
|00003b00| 65 72 69 6f 6e 20 77 69 | 6c 6c 20 62 65 20 63 61 |erion wi|ll be ca|
|00003b10| 6c 6c 65 64 20 61 20 70 | 68 72 61 73 65 2e 0d 0a |lled a p|hrase...|
|00003b20| 0d 0a 41 20 70 68 72 61 | 73 65 20 69 73 20 6d 61 |..A phra|se is ma|
|00003b30| 64 65 20 75 70 20 6f 66 | 20 74 68 65 20 66 6f 6c |de up of| the fol|
|00003b40| 6c 6f 77 69 6e 67 3a 0d | 0a 0d 0a 09 31 2e 20 46 |lowing:.|....1. F|
|00003b50| 49 45 4c 44 5f 4e 41 4d | 45 20 20 73 75 63 68 20 |IELD_NAM|E such |
|00003b60| 61 73 20 22 4c 61 73 74 | 5f 4e 61 6d 65 22 20 20 |as "Last|_Name" |
|00003b70| 20 20 20 20 20 20 0d 0a | 09 32 2e 20 4f 50 45 52 | ..|.2. OPER|
|00003b80| 41 54 4f 52 20 20 20 20 | 73 75 63 68 20 61 73 20 |ATOR |such as |
|00003b90| 22 62 65 67 69 6e 73 20 | 77 69 74 68 22 20 20 0d |"begins |with" .|
|00003ba0| 0a 09 33 2e 20 44 41 54 | 41 20 20 20 20 20 20 20 |..3. DAT|A |
|00003bb0| 20 73 75 63 68 20 61 73 | 20 22 53 6d 69 74 68 22 | such as| "Smith"|
|00003bc0| 20 20 0d 0a 09 0d 0a 09 | 45 78 61 6d 70 6c 65 3a | ......|Example:|
|00003bd0| 20 20 46 49 45 4c 44 5f | 4e 41 4d 45 20 20 20 4f | FIELD_|NAME O|
|00003be0| 50 45 52 41 54 4f 52 20 | 20 20 20 44 41 54 41 0d |PERATOR | DATA.|
|00003bf0| 0a 09 20 20 20 20 20 20 | 20 20 20 20 4c 61 73 74 |.. | Last|
|00003c00| 5f 4e 61 6d 65 20 20 20 | 20 62 65 67 69 6e 73 20 |_Name | begins |
|00003c10| 77 69 74 68 20 22 53 6d | 69 74 68 22 0d 0a 0d 0a |with "Sm|ith"....|
|00003c20| 41 6e 20 65 78 70 72 65 | 73 73 69 6f 6e 20 6d 61 |An expre|ssion ma|
|00003c30| 79 20 68 61 76 65 20 6d | 6f 72 65 20 74 68 61 6e |y have m|ore than|
|00003c40| 20 6f 6e 65 20 70 68 72 | 61 73 65 2e 20 54 68 69 | one phr|ase. Thi|
|00003c50| 73 20 61 6c 6c 6f 77 73 | 20 79 6f 75 20 74 6f 20 |s allows| you to |
|00003c60| 63 72 65 61 74 65 0d 0a | 73 6f 6d 65 20 76 65 72 |create..|some ver|
|00003c70| 79 20 73 6f 70 68 69 73 | 74 69 63 61 74 65 64 20 |y sophis|ticated |
|00003c80| 73 65 6c 65 63 74 69 6f | 6e 20 63 72 69 74 65 72 |selectio|n criter|
|00003c90| 69 61 2e 0d 0a 0d 0a 50 | 68 72 61 73 65 73 20 61 |ia.....P|hrases a|
|00003ca0| 72 65 20 63 6f 6d 62 69 | 6e 65 64 20 77 69 74 68 |re combi|ned with|
|00003cb0| 20 74 68 65 20 66 6f 6c | 6c 6f 77 69 6e 67 20 43 | the fol|lowing C|
|00003cc0| 4f 4e 4e 45 43 54 4f 52 | 53 3a 20 0d 0a 0d 0a 09 |ONNECTOR|S: .....|
|00003cd0| 31 2e 20 41 4e 44 20 2d | 6d 65 61 6e 73 20 62 6f |1. AND -|means bo|
|00003ce0| 74 68 20 70 68 72 61 73 | 65 73 20 6d 75 73 74 20 |th phras|es must |
|00003cf0| 62 65 20 74 72 75 65 20 | 20 0d 0a 09 32 2e 20 4f |be true | ...2. O|
|00003d00| 52 20 20 2d 6d 65 61 6e | 73 20 6f 6e 65 20 6f 66 |R -mean|s one of|
|00003d10| 20 74 68 65 20 70 68 72 | 61 73 65 73 20 6d 75 73 | the phr|ases mus|
|00003d20| 74 20 62 65 20 74 72 75 | 65 20 20 0d 0a 09 0d 0a |t be tru|e .....|
|00003d30| 09 45 78 61 6d 70 6c 65 | 3a 20 20 46 49 45 4c 44 |.Example|: FIELD|
|00003d40| 5f 4e 41 4d 45 20 20 20 | 4f 50 45 52 41 54 4f 52 |_NAME |OPERATOR|
|00003d50| 20 20 20 20 20 20 20 20 | 44 41 54 41 20 20 20 20 | |DATA |
|00003d60| 20 20 43 4f 4e 4e 45 43 | 54 4f 52 0d 0a 09 20 20 | CONNEC|TOR... |
|00003d70| 20 20 20 20 20 20 20 20 | 4c 61 73 74 5f 4e 61 6d | |Last_Nam|
|00003d80| 65 20 20 20 20 62 65 67 | 69 6e 73 20 77 69 74 68 |e beg|ins with|
|00003d90| 20 20 20 20 20 22 53 6d | 69 74 68 22 20 20 20 41 | "Sm|ith" A|
|00003da0| 4e 44 0d 0a 09 20 20 20 | 20 20 20 20 20 20 20 53 |ND... | S|
|00003db0| 45 58 20 20 20 20 20 20 | 20 20 20 20 69 73 20 74 |EX | is t|
|00003dc0| 68 65 20 73 61 6d 65 20 | 61 73 20 20 22 46 45 4d |he same |as "FEM|
|00003dd0| 41 4c 45 22 0d 0a 0d 0a | 49 6e 20 74 68 65 20 61 |ALE"....|In the a|
|00003de0| 62 6f 76 65 20 65 78 61 | 6d 70 6c 65 20 74 68 65 |bove exa|mple the|
|00003df0| 20 70 65 72 73 6f 6e 20 | 6d 75 73 74 20 68 61 76 | person |must hav|
|00003e00| 65 20 61 20 6c 61 73 74 | 20 6e 61 6d 65 20 74 68 |e a last| name th|
|00003e10| 61 74 20 62 65 67 69 6e | 73 20 77 69 74 68 0d 0a |at begin|s with..|
|00003e20| 22 53 6d 69 74 68 22 20 | 20 41 4e 44 20 20 74 68 |"Smith" | AND th|
|00003e30| 65 79 20 6d 75 73 74 20 | 62 65 20 61 20 66 65 6d |ey must |be a fem|
|00003e40| 61 6c 65 2e 0d 0a 49 66 | 20 74 68 65 20 63 6f 6e |ale...If| the con|
|00003e50| 6e 65 63 74 6f 72 20 77 | 65 72 65 20 61 6e 20 22 |nector w|ere an "|
|00003e60| 4f 52 22 20 74 68 65 6e | 20 74 68 65 20 70 65 72 |OR" then| the per|
|00003e70| 73 6f 6e 20 6d 75 73 74 | 20 68 61 76 65 20 61 20 |son must| have a |
|00003e80| 6c 61 73 74 20 6e 61 6d | 65 20 74 68 61 74 20 62 |last nam|e that b|
|00003e90| 65 67 69 6e 73 20 77 69 | 74 68 20 22 53 6d 69 74 |egins wi|th "Smit|
|00003ea0| 68 22 20 20 4f 52 20 20 | 74 68 65 79 20 6d 75 73 |h" OR |they mus|
|00003eb0| 74 20 62 65 20 61 20 66 | 65 6d 61 6c 65 2e 0d 0a |t be a f|emale...|
|00003ec0| 41 20 6c 69 73 74 20 6f | 66 20 70 65 6f 70 6c 65 |A list o|f people|
|00003ed0| 20 62 61 73 65 64 20 6f | 6e 20 74 68 65 20 41 4e | based o|n the AN|
|00003ee0| 44 20 43 4f 4e 4e 45 43 | 54 4f 52 20 77 6f 75 6c |D CONNEC|TOR woul|
|00003ef0| 64 20 62 65 20 66 65 6d | 61 6c 65 73 20 77 68 6f |d be fem|ales who|
|00003f00| 73 65 20 6c 61 73 74 0d | 0a 6e 61 6d 65 73 20 62 |se last.|.names b|
|00003f10| 65 67 69 6e 20 77 69 74 | 68 20 22 53 6d 69 74 68 |egin wit|h "Smith|
|00003f20| 22 2e 0d 0a 41 20 6c 69 | 73 74 20 6f 66 20 70 65 |"...A li|st of pe|
|00003f30| 6f 70 6c 65 20 62 61 73 | 65 64 20 6f 6e 20 74 68 |ople bas|ed on th|
|00003f40| 65 20 4f 52 20 43 4f 4e | 4e 45 43 54 4f 52 20 77 |e OR CON|NECTOR w|
|00003f50| 6f 75 6c 64 20 62 65 20 | 61 6c 6c 20 66 65 6d 61 |ould be |all fema|
|00003f60| 6c 65 73 20 6f 72 20 61 | 6e 79 62 6f 64 79 20 77 |les or a|nybody w|
|00003f70| 68 6f 73 65 20 6c 61 73 | 74 20 6e 61 6d 65 73 20 |hose las|t names |
|00003f80| 62 65 67 69 6e 20 77 69 | 74 68 20 22 53 6d 69 74 |begin wi|th "Smit|
|00003f90| 68 22 28 6d 61 6c 65 20 | 6f 72 20 66 65 6d 61 6c |h"(male |or femal|
|00003fa0| 65 29 2e 0d 0a 0d 0a 0d | 0a 50 68 72 61 73 65 73 |e)......|.Phrases|
|00003fb0| 20 6d 61 79 20 62 65 20 | 70 75 74 20 69 6e 20 64 | may be |put in d|
|00003fc0| 69 66 66 65 72 65 6e 74 | 20 67 72 6f 75 70 73 2e |ifferent| groups.|
|00003fd0| 20 54 68 65 20 70 68 72 | 61 73 65 73 20 69 6e 20 | The phr|ases in |
|00003fe0| 74 68 65 20 31 73 74 20 | 67 72 6f 75 70 20 61 72 |the 1st |group ar|
|00003ff0| 65 0d 0a 65 76 61 6c 75 | 61 74 65 64 20 61 73 20 |e..evalu|ated as |
|00004000| 61 20 67 72 6f 75 70 20 | 62 65 66 6f 72 65 20 74 |a group |before t|
|00004010| 68 65 20 70 68 72 61 73 | 65 73 20 69 6e 20 74 68 |he phras|es in th|
|00004020| 65 20 32 6e 64 20 67 72 | 6f 75 70 20 61 72 65 20 |e 2nd gr|oup are |
|00004030| 65 76 61 6c 75 61 74 65 | 64 2c 20 61 6e 64 20 74 |evaluate|d, and t|
|00004040| 68 65 20 70 68 72 61 73 | 65 73 20 69 6e 20 74 68 |he phras|es in th|
|00004050| 65 20 32 6e 64 20 67 72 | 6f 75 70 20 61 72 65 20 |e 2nd gr|oup are |
|00004060| 65 76 61 6c 75 61 74 65 | 64 20 61 73 20 61 20 67 |evaluate|d as a g|
|00004070| 72 6f 75 70 20 62 65 66 | 6f 72 65 20 74 68 65 20 |roup bef|ore the |
|00004080| 70 68 72 61 73 65 73 20 | 69 6e 20 74 68 65 20 33 |phrases |in the 3|
|00004090| 72 64 20 67 72 6f 75 70 | 20 61 72 65 20 65 76 61 |rd group| are eva|
|000040a0| 6c 75 61 74 65 64 2c 20 | 65 74 63 2e 2e 2e 0d 0a |luated, |etc.....|
|000040b0| 0d 0a 50 75 74 74 69 6e | 67 20 70 68 72 61 73 65 |..Puttin|g phrase|
|000040c0| 73 20 69 6e 20 61 20 64 | 69 66 66 65 72 65 6e 74 |s in a d|ifferent|
|000040d0| 20 67 72 6f 75 70 20 77 | 69 6c 6c 20 6e 6f 72 6d | group w|ill norm|
|000040e0| 61 6c 6c 79 20 6e 6f 74 | 20 62 65 20 6e 65 63 65 |ally not| be nece|
|000040f0| 73 73 61 72 79 20 75 6e | 6c 65 73 73 20 74 68 65 |ssary un|less the|
|00004100| 20 73 65 6c 65 63 74 69 | 6f 6e 20 63 72 69 74 65 | selecti|on crite|
|00004110| 72 69 61 20 61 72 65 20 | 76 65 72 79 20 63 6f 6d |ria are |very com|
|00004120| 70 6c 69 63 61 74 65 64 | 2e 0d 0a 0d 0a 0d 0a 09 |plicated|........|
|00004130| 45 78 61 6d 70 6c 65 3a | 20 20 46 49 45 4c 44 5f |Example:| FIELD_|
|00004140| 4e 41 4d 45 20 20 20 4f | 50 45 52 41 54 4f 52 20 |NAME O|PERATOR |
|00004150| 20 20 20 20 20 20 20 44 | 41 54 41 20 20 20 20 20 | D|ATA |
|00004160| 20 43 4f 4e 4e 45 43 54 | 4f 52 20 20 47 52 4f 55 | CONNECT|OR GROU|
|00004170| 50 0d 0a 09 20 20 20 20 | 20 20 20 20 20 20 4c 41 |P... | LA|
|00004180| 53 54 5f 4e 41 4d 45 20 | 20 20 20 62 65 67 69 6e |ST_NAME | begin|
|00004190| 73 20 77 69 74 68 20 20 | 20 20 20 22 53 6d 69 74 |s with | "Smit|
|000041a0| 68 22 20 20 20 4f 52 20 | 20 20 20 20 20 20 20 20 |h" OR | |
|000041b0| 31 0d 0a 09 20 20 20 20 | 20 20 20 20 20 20 53 45 |1... | SE|
|000041c0| 58 20 20 20 20 20 20 20 | 20 20 20 69 73 20 74 68 |X | is th|
|000041d0| 65 20 73 61 6d 65 20 61 | 73 20 20 22 46 45 4d 41 |e same a|s "FEMA|
|000041e0| 4c 45 22 20 20 41 4e 44 | 20 20 20 20 20 20 20 20 |LE" AND| |
|000041f0| 31 0d 0a 09 20 20 20 20 | 20 20 20 20 20 20 50 48 |1... | PH|
|00004200| 4f 4e 45 20 20 20 20 20 | 20 20 20 43 4f 4e 54 41 |ONE | CONTA|
|00004210| 49 4e 53 20 20 20 20 20 | 20 20 20 22 31 32 33 22 |INS | "123"|
|00004220| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004230| 32 0d 0a 09 20 20 20 20 | 20 20 20 20 20 20 20 0d |2... | .|
|00004240| 0a 0d 0a 49 6e 20 74 68 | 65 20 61 62 6f 76 65 20 |...In th|e above |
|00004250| 65 78 61 6d 70 6c 65 20 | 74 68 65 20 70 65 72 73 |example |the pers|
|00004260| 6f 6e 20 6d 75 73 74 20 | 68 61 76 65 20 61 20 6c |on must |have a l|
|00004270| 61 73 74 20 6e 61 6d 65 | 20 74 68 61 74 20 62 65 |ast name| that be|
|00004280| 67 69 6e 73 20 77 69 74 | 68 0d 0a 22 53 6d 69 74 |gins wit|h.."Smit|
|00004290| 68 22 20 20 4f 52 20 20 | 74 68 65 79 20 6d 75 73 |h" OR |they mus|
|000042a0| 74 20 62 65 20 61 20 66 | 65 6d 61 6c 65 2e 20 0d |t be a f|emale. .|
|000042b0| 0a 41 6e 79 6f 6e 65 20 | 6d 61 74 63 68 69 6e 67 |.Anyone |matching|
|000042c0| 20 74 68 65 20 61 62 6f | 76 65 20 63 72 69 74 65 | the abo|ve crite|
|000042d0| 72 69 61 20 6d 75 73 74 | 20 61 6c 73 6f 20 68 61 |ria must| also ha|
|000042e0| 76 65 20 61 20 70 68 6f | 6e 65 20 6e 75 6d 62 65 |ve a pho|ne numbe|
|000042f0| 72 20 74 68 61 74 0d 0a | 63 6f 6e 74 61 69 6e 73 |r that..|contains|
|00004300| 20 22 31 32 33 22 2e 0d | 0a 49 74 20 77 6f 75 6c | "123"..|.It woul|
|00004310| 64 20 6c 69 73 74 20 72 | 65 63 6f 72 64 73 20 6c |d list r|ecords l|
|00004320| 69 6b 65 3a 0d 0a 0d 0a | 09 4e 61 6d 65 20 20 20 |ike:....|.Name |
|00004330| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004340| 20 20 53 65 78 20 20 20 | 20 20 20 20 20 20 20 20 | Sex | |
|00004350| 20 20 20 20 20 20 20 50 | 68 6f 6e 65 0d 0a 20 20 | P|hone.. |
|00004360| 20 1a 42 69 6c 6c 20 53 | 6d 69 74 68 20 20 20 20 | .Bill S|mith |
|00004370| 20 20 20 20 20 20 20 20 | 20 20 20 4d 61 6c 65 20 | | Male |
|00004380| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 1a | | .|
|00004390| 34 34 34 2d 31 32 33 34 | 0d 0a 09 4a 61 6e 65 20 |444-1234|...Jane |
|000043a0| 44 6f 65 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |Doe | |
|000043b0| 20 20 20 1a 46 65 6d 61 | 6c 65 20 20 20 20 20 20 | .Fema|le |
|000043c0| 20 20 20 20 20 20 20 20 | 1a 31 32 33 2d 34 34 34 | |.123-444|
|000043d0| 34 20 0d 0a 09 20 0d 0a | 28 22 1a 22 20 6d 61 72 |4 ... ..|("." mar|
|000043e0| 6b 73 20 6d 61 74 63 68 | 69 6e 67 20 63 72 69 74 |ks match|ing crit|
|000043f0| 65 72 69 61 29 09 20 0d | 0a 0d 0a 49 74 20 77 6f |eria). .|...It wo|
|00004400| 75 6c 64 20 6e 6f 74 20 | 6c 69 73 74 20 72 65 63 |uld not |list rec|
|00004410| 6f 72 64 73 20 6c 69 6b | 65 3a 0d 0a 0d 0a 09 4e |ords lik|e:.....N|
|00004420| 61 6d 65 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |ame | |
|00004430| 20 20 20 20 20 20 20 20 | 53 65 78 20 20 20 20 20 | |Sex |
|00004440| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 50 68 6f | | Pho|
|00004450| 6e 65 0d 0a 20 20 20 1a | 42 69 6c 6c 20 4e 61 69 |ne.. .|Bill Nai|
|00004460| 73 6d 69 74 68 20 20 20 | 20 20 20 20 20 20 20 20 |smith | |
|00004470| 1a 4d 61 6c 65 20 20 20 | 20 20 20 20 20 20 20 20 |.Male | |
|00004480| 20 20 20 20 20 20 34 34 | 34 2d 31 32 33 34 0d 0a | 44|4-1234..|
|00004490| 20 20 20 1a 4a 61 6e 65 | 20 44 6f 65 20 20 20 20 | .Jane| Doe |
|000044a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 66 65 6d | | fem|
|000044b0| 61 6c 65 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |ale | |
|000044c0| 20 1a 33 33 33 2d 34 34 | 34 34 20 0d 0a 09 20 0d | .333-44|44 ... .|
|000044d0| 0a 28 22 1a 22 20 6d 61 | 72 6b 73 20 6e 6f 6e 65 |.("." ma|rks none|
|000044e0| 20 6d 61 74 63 68 69 6e | 67 20 63 72 69 74 65 72 | matchin|g criter|
|000044f0| 69 61 29 09 20 0d 0a 0a | 0d 0a 0d 0a 53 62 3a 20 |ia). ...|....Sb: |
|00004500| 00 00 00 01 00 00 0b 11 | 54 68 69 73 20 69 73 20 |........|This is |
|00004510| 61 20 63 75 73 74 6f 6d | 20 65 78 70 72 65 73 73 |a custom| express|
|00004520| 69 6f 6e 20 62 75 69 6c | 64 65 72 2e 0d 0a 0d 0a |ion buil|der.....|
|00004530| 41 6e 20 65 78 70 72 65 | 73 73 69 6f 6e 20 69 73 |An expre|ssion is|
|00004540| 20 6f 6e 65 20 6f 72 20 | 6d 6f 72 65 20 73 65 6c | one or |more sel|
|00004550| 65 63 74 69 6f 6e 20 63 | 72 69 74 65 72 69 61 20 |ection c|riteria |
|00004560| 63 6f 6d 62 69 6e 65 64 | 2e 0d 0a 0d 0a 45 61 63 |combined|.....Eac|
|00004570| 68 20 73 65 6c 65 63 74 | 69 6f 6e 20 63 72 69 74 |h select|ion crit|
|00004580| 65 72 69 6f 6e 20 77 69 | 6c 6c 20 62 65 20 63 61 |erion wi|ll be ca|
|00004590| 6c 6c 65 64 20 61 20 70 | 68 72 61 73 65 2e 0d 0a |lled a p|hrase...|
|000045a0| 0d 0a 41 20 70 68 72 61 | 73 65 20 69 73 20 6d 61 |..A phra|se is ma|
|000045b0| 64 65 20 75 70 20 6f 66 | 20 74 68 65 20 66 6f 6c |de up of| the fol|
|000045c0| 6c 6f 77 69 6e 67 3a 0d | 0a 0d 0a 09 31 2e 20 46 |lowing:.|....1. F|
|000045d0| 49 45 4c 44 5f 4e 41 4d | 45 20 20 73 75 63 68 20 |IELD_NAM|E such |
|000045e0| 61 73 20 22 4c 61 73 74 | 5f 4e 61 6d 65 22 20 20 |as "Last|_Name" |
|000045f0| 20 20 20 20 20 20 0d 0a | 09 32 2e 20 4f 50 45 52 | ..|.2. OPER|
|00004600| 41 54 4f 52 20 20 20 20 | 73 75 63 68 20 61 73 20 |ATOR |such as |
|00004610| 22 62 65 67 69 6e 73 20 | 77 69 74 68 22 20 20 0d |"begins |with" .|
|00004620| 0a 09 33 2e 20 44 41 54 | 41 20 20 20 20 20 20 20 |..3. DAT|A |
|00004630| 20 73 75 63 68 20 61 73 | 20 22 53 6d 69 74 68 22 | such as| "Smith"|
|00004640| 20 20 0d 0a 09 0d 0a 09 | 45 78 61 6d 70 6c 65 3a | ......|Example:|
|00004650| 20 20 46 49 45 4c 44 5f | 4e 41 4d 45 20 20 20 4f | FIELD_|NAME O|
|00004660| 50 45 52 41 54 4f 52 20 | 20 20 20 44 41 54 41 0d |PERATOR | DATA.|
|00004670| 0a 09 20 20 20 20 20 20 | 20 20 20 20 4c 61 73 74 |.. | Last|
|00004680| 5f 4e 61 6d 65 20 20 20 | 20 62 65 67 69 6e 73 20 |_Name | begins |
|00004690| 77 69 74 68 20 22 53 6d | 69 74 68 22 0d 0a 0d 0a |with "Sm|ith"....|
|000046a0| 41 6e 20 65 78 70 72 65 | 73 73 69 6f 6e 20 6d 61 |An expre|ssion ma|
|000046b0| 79 20 68 61 76 65 20 6d | 6f 72 65 20 74 68 61 6e |y have m|ore than|
|000046c0| 20 6f 6e 65 20 70 68 72 | 61 73 65 2e 20 54 68 69 | one phr|ase. Thi|
|000046d0| 73 20 61 6c 6c 6f 77 73 | 20 79 6f 75 20 74 6f 20 |s allows| you to |
|000046e0| 63 72 65 61 74 65 0d 0a | 73 6f 6d 65 20 76 65 72 |create..|some ver|
|000046f0| 79 20 73 6f 70 68 69 73 | 74 69 63 61 74 65 64 20 |y sophis|ticated |
|00004700| 73 65 6c 65 63 74 69 6f | 6e 20 63 72 69 74 65 72 |selectio|n criter|
|00004710| 69 61 2e 0d 0a 0d 0a 50 | 68 72 61 73 65 73 20 61 |ia.....P|hrases a|
|00004720| 72 65 20 63 6f 6d 62 69 | 6e 65 64 20 77 69 74 68 |re combi|ned with|
|00004730| 20 74 68 65 20 66 6f 6c | 6c 6f 77 69 6e 67 20 43 | the fol|lowing C|
|00004740| 4f 4e 4e 45 43 54 4f 52 | 53 3a 20 0d 0a 0d 0a 09 |ONNECTOR|S: .....|
|00004750| 31 2e 20 41 4e 44 20 2d | 6d 65 61 6e 73 20 62 6f |1. AND -|means bo|
|00004760| 74 68 20 70 68 72 61 73 | 65 73 20 6d 75 73 74 20 |th phras|es must |
|00004770| 62 65 20 74 72 75 65 20 | 20 0d 0a 09 32 2e 20 4f |be true | ...2. O|
|00004780| 52 20 20 2d 6d 65 61 6e | 73 20 6f 6e 65 20 6f 66 |R -mean|s one of|
|00004790| 20 74 68 65 20 70 68 72 | 61 73 65 73 20 6d 75 73 | the phr|ases mus|
|000047a0| 74 20 62 65 20 74 72 75 | 65 20 20 0d 0a 09 0d 0a |t be tru|e .....|
|000047b0| 09 45 78 61 6d 70 6c 65 | 3a 20 20 46 49 45 4c 44 |.Example|: FIELD|
|000047c0| 5f 4e 41 4d 45 20 20 20 | 4f 50 45 52 41 54 4f 52 |_NAME |OPERATOR|
|000047d0| 20 20 20 20 20 20 20 20 | 44 41 54 41 20 20 20 20 | |DATA |
|000047e0| 20 20 43 4f 4e 4e 45 43 | 54 4f 52 0d 0a 09 20 20 | CONNEC|TOR... |
|000047f0| 20 20 20 20 20 20 20 20 | 4c 61 73 74 5f 4e 61 6d | |Last_Nam|
|00004800| 65 20 20 20 20 62 65 67 | 69 6e 73 20 77 69 74 68 |e beg|ins with|
|00004810| 20 20 20 20 20 22 53 6d | 69 74 68 22 20 20 20 41 | "Sm|ith" A|
|00004820| 4e 44 0d 0a 09 20 20 20 | 20 20 20 20 20 20 20 53 |ND... | S|
|00004830| 45 58 20 20 20 20 20 20 | 20 20 20 20 69 73 20 74 |EX | is t|
|00004840| 68 65 20 73 61 6d 65 20 | 61 73 20 20 22 46 45 4d |he same |as "FEM|
|00004850| 41 4c 45 22 0d 0a 0d 0a | 49 6e 20 74 68 65 20 61 |ALE"....|In the a|
|00004860| 62 6f 76 65 20 65 78 61 | 6d 70 6c 65 20 74 68 65 |bove exa|mple the|
|00004870| 20 70 65 72 73 6f 6e 20 | 6d 75 73 74 20 68 61 76 | person |must hav|
|00004880| 65 20 61 20 6c 61 73 74 | 20 6e 61 6d 65 20 74 68 |e a last| name th|
|00004890| 61 74 20 62 65 67 69 6e | 73 20 77 69 74 68 0d 0a |at begin|s with..|
|000048a0| 22 53 6d 69 74 68 22 20 | 20 41 4e 44 20 20 74 68 |"Smith" | AND th|
|000048b0| 65 79 20 6d 75 73 74 20 | 62 65 20 61 20 66 65 6d |ey must |be a fem|
|000048c0| 61 6c 65 2e 0d 0a 49 66 | 20 74 68 65 20 63 6f 6e |ale...If| the con|
|000048d0| 6e 65 63 74 6f 72 20 77 | 65 72 65 20 61 6e 20 22 |nector w|ere an "|
|000048e0| 4f 52 22 20 74 68 65 6e | 20 74 68 65 20 70 65 72 |OR" then| the per|
|000048f0| 73 6f 6e 20 6d 75 73 74 | 20 68 61 76 65 20 61 20 |son must| have a |
|00004900| 6c 61 73 74 20 6e 61 6d | 65 20 74 68 61 74 20 62 |last nam|e that b|
|00004910| 65 67 69 6e 73 20 77 69 | 74 68 20 22 53 6d 69 74 |egins wi|th "Smit|
|00004920| 68 22 20 20 4f 52 20 20 | 74 68 65 79 20 6d 75 73 |h" OR |they mus|
|00004930| 74 20 62 65 20 61 20 66 | 65 6d 61 6c 65 2e 0d 0a |t be a f|emale...|
|00004940| 41 20 6c 69 73 74 20 6f | 66 20 70 65 6f 70 6c 65 |A list o|f people|
|00004950| 20 62 61 73 65 64 20 6f | 6e 20 74 68 65 20 41 4e | based o|n the AN|
|00004960| 44 20 43 4f 4e 4e 45 43 | 54 4f 52 20 77 6f 75 6c |D CONNEC|TOR woul|
|00004970| 64 20 62 65 20 66 65 6d | 61 6c 65 73 20 77 68 6f |d be fem|ales who|
|00004980| 73 65 20 6c 61 73 74 0d | 0a 6e 61 6d 65 73 20 62 |se last.|.names b|
|00004990| 65 67 69 6e 20 77 69 74 | 68 20 22 53 6d 69 74 68 |egin wit|h "Smith|
|000049a0| 22 2e 0d 0a 41 20 6c 69 | 73 74 20 6f 66 20 70 65 |"...A li|st of pe|
|000049b0| 6f 70 6c 65 20 62 61 73 | 65 64 20 6f 6e 20 74 68 |ople bas|ed on th|
|000049c0| 65 20 4f 52 20 43 4f 4e | 4e 45 43 54 4f 52 20 77 |e OR CON|NECTOR w|
|000049d0| 6f 75 6c 64 20 62 65 20 | 61 6c 6c 20 66 65 6d 61 |ould be |all fema|
|000049e0| 6c 65 73 20 6f 72 20 61 | 6e 79 62 6f 64 79 20 77 |les or a|nybody w|
|000049f0| 68 6f 73 65 20 6c 61 73 | 74 20 6e 61 6d 65 73 20 |hose las|t names |
|00004a00| 62 65 67 69 6e 20 77 69 | 74 68 20 22 53 6d 69 74 |begin wi|th "Smit|
|00004a10| 68 22 28 6d 61 6c 65 20 | 6f 72 20 66 65 6d 61 6c |h"(male |or femal|
|00004a20| 65 29 2e 0d 0a 0d 0a 0d | 0a 50 68 72 61 73 65 73 |e)......|.Phrases|
|00004a30| 20 6d 61 79 20 62 65 20 | 70 75 74 20 69 6e 20 64 | may be |put in d|
|00004a40| 69 66 66 65 72 65 6e 74 | 20 67 72 6f 75 70 73 2e |ifferent| groups.|
|00004a50| 20 54 68 65 20 70 68 72 | 61 73 65 73 20 69 6e 20 | The phr|ases in |
|00004a60| 74 68 65 20 31 73 74 20 | 67 72 6f 75 70 20 61 72 |the 1st |group ar|
|00004a70| 65 0d 0a 65 76 61 6c 75 | 61 74 65 64 20 61 73 20 |e..evalu|ated as |
|00004a80| 61 20 67 72 6f 75 70 20 | 62 65 66 6f 72 65 20 74 |a group |before t|
|00004a90| 68 65 20 70 68 72 61 73 | 65 73 20 69 6e 20 74 68 |he phras|es in th|
|00004aa0| 65 20 32 6e 64 20 67 72 | 6f 75 70 20 61 72 65 20 |e 2nd gr|oup are |
|00004ab0| 65 76 61 6c 75 61 74 65 | 64 2c 20 61 6e 64 20 74 |evaluate|d, and t|
|00004ac0| 68 65 20 70 68 72 61 73 | 65 73 20 69 6e 20 74 68 |he phras|es in th|
|00004ad0| 65 20 32 6e 64 20 67 72 | 6f 75 70 20 61 72 65 20 |e 2nd gr|oup are |
|00004ae0| 65 76 61 6c 75 61 74 65 | 64 20 61 73 20 61 20 67 |evaluate|d as a g|
|00004af0| 72 6f 75 70 20 62 65 66 | 6f 72 65 20 74 68 65 20 |roup bef|ore the |
|00004b00| 70 68 72 61 73 65 73 20 | 69 6e 20 74 68 65 20 33 |phrases |in the 3|
|00004b10| 72 64 20 67 72 6f 75 70 | 20 61 72 65 20 65 76 61 |rd group| are eva|
|00004b20| 6c 75 61 74 65 64 2c 20 | 65 74 63 2e 2e 2e 0d 0a |luated, |etc.....|
|00004b30| 0d 0a 50 75 74 74 69 6e | 67 20 70 68 72 61 73 65 |..Puttin|g phrase|
|00004b40| 73 20 69 6e 20 61 20 64 | 69 66 66 65 72 65 6e 74 |s in a d|ifferent|
|00004b50| 20 67 72 6f 75 70 20 77 | 69 6c 6c 20 6e 6f 72 6d | group w|ill norm|
|00004b60| 61 6c 6c 79 20 6e 6f 74 | 20 62 65 20 6e 65 63 65 |ally not| be nece|
|00004b70| 73 73 61 72 79 20 75 6e | 6c 65 73 73 20 74 68 65 |ssary un|less the|
|00004b80| 20 73 65 6c 65 63 74 69 | 6f 6e 20 63 72 69 74 65 | selecti|on crite|
|00004b90| 72 69 61 20 61 72 65 20 | 76 65 72 79 20 63 6f 6d |ria are |very com|
|00004ba0| 70 6c 69 63 61 74 65 64 | 2e 0d 0a 0d 0a 0d 0a 09 |plicated|........|
|00004bb0| 45 78 61 6d 70 6c 65 3a | 20 20 46 49 45 4c 44 5f |Example:| FIELD_|
|00004bc0| 4e 41 4d 45 20 20 20 4f | 50 45 52 41 54 4f 52 20 |NAME O|PERATOR |
|00004bd0| 20 20 20 20 20 20 20 44 | 41 54 41 20 20 20 20 20 | D|ATA |
|00004be0| 20 43 4f 4e 4e 45 43 54 | 4f 52 20 20 47 52 4f 55 | CONNECT|OR GROU|
|00004bf0| 50 0d 0a 09 20 20 20 20 | 20 20 20 20 20 20 4c 41 |P... | LA|
|00004c00| 53 54 5f 4e 41 4d 45 20 | 20 20 20 62 65 67 69 6e |ST_NAME | begin|
|00004c10| 73 20 77 69 74 68 20 20 | 20 20 20 22 53 6d 69 74 |s with | "Smit|
|00004c20| 68 22 20 20 20 4f 52 20 | 20 20 20 20 20 20 20 20 |h" OR | |
|00004c30| 31 0d 0a 09 20 20 20 20 | 20 20 20 20 20 20 53 45 |1... | SE|
|00004c40| 58 20 20 20 20 20 20 20 | 20 20 20 69 73 20 74 68 |X | is th|
|00004c50| 65 20 73 61 6d 65 20 61 | 73 20 20 22 46 45 4d 41 |e same a|s "FEMA|
|00004c60| 4c 45 22 20 20 41 4e 44 | 20 20 20 20 20 20 20 20 |LE" AND| |
|00004c70| 31 0d 0a 09 20 20 20 20 | 20 20 20 20 20 20 50 48 |1... | PH|
|00004c80| 4f 4e 45 20 20 20 20 20 | 20 20 20 43 4f 4e 54 41 |ONE | CONTA|
|00004c90| 49 4e 53 20 20 20 20 20 | 20 20 20 22 31 32 33 22 |INS | "123"|
|00004ca0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004cb0| 32 0d 0a 09 20 20 20 20 | 20 20 20 20 20 20 20 0d |2... | .|
|00004cc0| 0a 0d 0a 49 6e 20 74 68 | 65 20 61 62 6f 76 65 20 |...In th|e above |
|00004cd0| 65 78 61 6d 70 6c 65 20 | 74 68 65 20 70 65 72 73 |example |the pers|
|00004ce0| 6f 6e 20 6d 75 73 74 20 | 68 61 76 65 20 61 20 6c |on must |have a l|
|00004cf0| 61 73 74 20 6e 61 6d 65 | 20 74 68 61 74 20 62 65 |ast name| that be|
|00004d00| 67 69 6e 73 20 77 69 74 | 68 0d 0a 22 53 6d 69 74 |gins wit|h.."Smit|
|00004d10| 68 22 20 20 4f 52 20 20 | 74 68 65 79 20 6d 75 73 |h" OR |they mus|
|00004d20| 74 20 62 65 20 61 20 66 | 65 6d 61 6c 65 2e 20 0d |t be a f|emale. .|
|00004d30| 0a 41 6e 79 6f 6e 65 20 | 6d 61 74 63 68 69 6e 67 |.Anyone |matching|
|00004d40| 20 74 68 65 20 61 62 6f | 76 65 20 63 72 69 74 65 | the abo|ve crite|
|00004d50| 72 69 61 20 6d 75 73 74 | 20 61 6c 73 6f 20 68 61 |ria must| also ha|
|00004d60| 76 65 20 61 20 70 68 6f | 6e 65 20 6e 75 6d 62 65 |ve a pho|ne numbe|
|00004d70| 72 20 74 68 61 74 0d 0a | 63 6f 6e 74 61 69 6e 73 |r that..|contains|
|00004d80| 20 22 31 32 33 22 2e 0d | 0a 49 74 20 77 6f 75 6c | "123"..|.It woul|
|00004d90| 64 20 6c 69 73 74 20 72 | 65 63 6f 72 64 73 20 6c |d list r|ecords l|
|00004da0| 69 6b 65 3a 0d 0a 0d 0a | 09 4e 61 6d 65 20 20 20 |ike:....|.Name |
|00004db0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004dc0| 20 20 53 65 78 20 20 20 | 20 20 20 20 20 20 20 20 | Sex | |
|00004dd0| 20 20 20 20 20 20 20 50 | 68 6f 6e 65 0d 0a 20 20 | P|hone.. |
|00004de0| 20 1a 42 69 6c 6c 20 53 | 6d 69 74 68 20 20 20 20 | .Bill S|mith |
|00004df0| 20 20 20 20 20 20 20 20 | 20 20 20 4d 61 6c 65 20 | | Male |
|00004e00| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 1a | | .|
|00004e10| 34 34 34 2d 31 32 33 34 | 0d 0a 09 4a 61 6e 65 20 |444-1234|...Jane |
|00004e20| 44 6f 65 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |Doe | |
|00004e30| 20 20 20 1a 46 65 6d 61 | 6c 65 20 20 20 20 20 20 | .Fema|le |
|00004e40| 20 20 20 20 20 20 20 20 | 1a 31 32 33 2d 34 34 34 | |.123-444|
|00004e50| 34 20 0d 0a 09 20 0d 0a | 28 22 1a 22 20 6d 61 72 |4 ... ..|("." mar|
|00004e60| 6b 73 20 6d 61 74 63 68 | 69 6e 67 20 63 72 69 74 |ks match|ing crit|
|00004e70| 65 72 69 61 29 09 20 0d | 0a 0d 0a 49 74 20 77 6f |eria). .|...It wo|
|00004e80| 75 6c 64 20 6e 6f 74 20 | 6c 69 73 74 20 72 65 63 |uld not |list rec|
|00004e90| 6f 72 64 73 20 6c 69 6b | 65 3a 0d 0a 0d 0a 09 4e |ords lik|e:.....N|
|00004ea0| 61 6d 65 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |ame | |
|00004eb0| 20 20 20 20 20 20 20 20 | 53 65 78 20 20 20 20 20 | |Sex |
|00004ec0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 50 68 6f | | Pho|
|00004ed0| 6e 65 0d 0a 20 20 20 1a | 42 69 6c 6c 20 4e 61 69 |ne.. .|Bill Nai|
|00004ee0| 73 6d 69 74 68 20 20 20 | 20 20 20 20 20 20 20 20 |smith | |
|00004ef0| 1a 4d 61 6c 65 20 20 20 | 20 20 20 20 20 20 20 20 |.Male | |
|00004f00| 20 20 20 20 20 20 34 34 | 34 2d 31 32 33 34 0d 0a | 44|4-1234..|
|00004f10| 20 20 20 1a 4a 61 6e 65 | 20 44 6f 65 20 20 20 20 | .Jane| Doe |
|00004f20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 66 65 6d | | fem|
|00004f30| 61 6c 65 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |ale | |
|00004f40| 20 1a 33 33 33 2d 34 34 | 34 34 20 0d 0a 09 20 0d | .333-44|44 ... .|
|00004f50| 0a 28 22 1a 22 20 6d 61 | 72 6b 73 20 6e 6f 6e 65 |.("." ma|rks none|
|00004f60| 20 6d 61 74 63 68 69 6e | 67 20 63 72 69 74 65 72 | matchin|g criter|
|00004f70| 69 61 29 09 20 0d 0a 0d | 0a 0d 0a 0d 0a 54 68 65 |ia). ...|.....The|
|00004f80| 20 46 6f 78 50 72 6f 20 | 65 78 70 72 65 73 73 69 | FoxPro |expressi|
|00004f90| 6f 6e 20 62 75 69 6c 64 | 65 72 20 69 73 20 61 6c |on build|er is al|
|00004fa0| 73 6f 20 61 76 61 69 6c | 61 62 6c 65 20 69 6e 20 |so avail|able in |
|00004fb0| 74 68 69 73 20 65 78 70 | 72 65 73 73 69 6f 6e 20 |this exp|ression |
|00004fc0| 62 75 69 6c 64 65 72 2c | 0d 0a 62 75 74 20 69 74 |builder,|..but it|
|00004fd0| 20 69 73 20 6e 6f 74 20 | 72 65 63 6f 6d 6d 65 6e | is not |recommen|
|00004fe0| 64 65 64 20 75 6e 6c 65 | 73 73 20 79 6f 75 20 61 |ded unle|ss you a|
|00004ff0| 72 65 20 66 61 6d 69 6c | 69 61 72 20 77 69 74 68 |re famil|iar with|
|00005000| 20 74 68 65 20 46 6f 78 | 50 72 6f 20 73 6f 66 74 | the Fox|Pro soft|
|00005010| 77 61 72 65 2e 0d 0a 0d | 0a a0 1a 00 8a e0 89 07 |ware....|........|
|00005020| 58 5b 1f 00 1d 22 00 e9 | db fe 1e 53 50 b4 51 cd |X[..."..|...SP.Q.|
|00005030| 21 00 1e 22 8e db c5 1e | 34 00 89 07 58 5b 1f 00 |!.."....|4...X[..|
|00005040| 00 00 00 01 00 00 0b 97 | 54 68 69 73 20 69 73 20 |........|This is |
|00005050| 61 20 63 75 73 74 6f 6d | 20 65 78 70 72 65 73 73 |a custom| express|
|00005060| 69 6f 6e 20 62 75 69 6c | 64 65 72 2e 0d 0a 0d 0a |ion buil|der.....|
|00005070| 41 6e 20 65 78 70 72 65 | 73 73 69 6f 6e 20 69 73 |An expre|ssion is|
|00005080| 20 6f 6e 65 20 6f 72 20 | 6d 6f 72 65 20 73 65 6c | one or |more sel|
|00005090| 65 63 74 69 6f 6e 20 63 | 72 69 74 65 72 69 61 20 |ection c|riteria |
|000050a0| 63 6f 6d 62 69 6e 65 64 | 2e 0d 0a 0d 0a 45 61 63 |combined|.....Eac|
|000050b0| 68 20 73 65 6c 65 63 74 | 69 6f 6e 20 63 72 69 74 |h select|ion crit|
|000050c0| 65 72 69 6f 6e 20 77 69 | 6c 6c 20 62 65 20 63 61 |erion wi|ll be ca|
|000050d0| 6c 6c 65 64 20 61 20 70 | 68 72 61 73 65 2e 0d 0a |lled a p|hrase...|
|000050e0| 0d 0a 41 20 70 68 72 61 | 73 65 20 69 73 20 6d 61 |..A phra|se is ma|
|000050f0| 64 65 20 75 70 20 6f 66 | 20 74 68 65 20 66 6f 6c |de up of| the fol|
|00005100| 6c 6f 77 69 6e 67 3a 0d | 0a 0d 0a 09 31 2e 20 46 |lowing:.|....1. F|
|00005110| 49 45 4c 44 5f 4e 41 4d | 45 20 20 73 75 63 68 20 |IELD_NAM|E such |
|00005120| 61 73 20 22 4c 61 73 74 | 5f 4e 61 6d 65 22 20 0d |as "Last|_Name" .|
|00005130| 0a 09 32 2e 20 4f 50 45 | 52 41 54 4f 52 20 20 20 |..2. OPE|RATOR |
|00005140| 20 73 75 63 68 20 61 73 | 20 22 62 65 67 69 6e 73 | such as| "begins|
|00005150| 20 77 69 74 68 22 20 0d | 0a 09 33 2e 20 44 41 54 | with" .|..3. DAT|
|00005160| 41 20 20 20 20 20 20 20 | 20 73 75 63 68 20 61 73 |A | such as|
|00005170| 20 22 53 6d 69 74 68 22 | 20 0d 0a 09 0d 0a 09 45 | "Smith"| ......E|
|00005180| 78 61 6d 70 6c 65 3a 20 | 20 46 49 45 4c 44 5f 4e |xample: | FIELD_N|
|00005190| 41 4d 45 20 20 20 4f 50 | 45 52 41 54 4f 52 20 20 |AME OP|ERATOR |
|000051a0| 20 20 44 41 54 41 0d 0a | 09 20 20 20 20 20 20 20 | DATA..|. |
|000051b0| 20 20 20 4c 61 73 74 5f | 4e 61 6d 65 20 20 20 20 | Last_|Name |
|000051c0| 62 65 67 69 6e 73 20 77 | 69 74 68 20 22 53 6d 69 |begins w|ith "Smi|
|000051d0| 74 68 22 0d 0a 0d 0a 41 | 6e 20 65 78 70 72 65 73 |th"....A|n expres|
|000051e0| 73 69 6f 6e 20 6d 61 79 | 20 68 61 76 65 20 6d 6f |sion may| have mo|
|000051f0| 72 65 20 74 68 61 6e 20 | 6f 6e 65 20 70 68 72 61 |re than |one phra|
|00005200| 73 65 2e 20 54 68 69 73 | 20 61 6c 6c 6f 77 73 20 |se. This| allows |
|00005210| 79 6f 75 20 74 6f 20 63 | 72 65 61 74 65 20 73 6f |you to c|reate so|
|00005220| 6d 65 20 76 65 72 79 20 | 73 6f 70 68 69 73 74 69 |me very |sophisti|
|00005230| 63 61 74 65 64 20 73 65 | 6c 65 63 74 69 6f 6e 20 |cated se|lection |
|00005240| 63 72 69 74 65 72 69 61 | 2e 0d 0a 0d 0a 50 68 72 |criteria|.....Phr|
|00005250| 61 73 65 73 20 61 72 65 | 20 63 6f 6d 62 69 6e 65 |ases are| combine|
|00005260| 64 20 77 69 74 68 20 74 | 68 65 20 66 6f 6c 6c 6f |d with t|he follo|
|00005270| 77 69 6e 67 20 43 4f 4e | 4e 45 43 54 4f 52 53 3a |wing CON|NECTORS:|
|00005280| 20 0d 0a 0d 0a 09 31 2e | 20 41 4e 44 20 2d 6d 65 | .....1.| AND -me|
|00005290| 61 6e 73 20 62 6f 74 68 | 20 70 68 72 61 73 65 73 |ans both| phrases|
|000052a0| 20 6d 75 73 74 20 62 65 | 20 74 72 75 65 0d 0a 09 | must be| true...|
|000052b0| 32 2e 20 4f 52 20 20 2d | 6d 65 61 6e 73 20 6f 6e |2. OR -|means on|
|000052c0| 65 20 6f 66 20 74 68 65 | 20 70 68 72 61 73 65 73 |e of the| phrases|
|000052d0| 20 6d 75 73 74 20 62 65 | 20 74 72 75 65 0d 0a 09 | must be| true...|
|000052e0| 0d 0a 09 45 78 61 6d 70 | 6c 65 3a 20 20 46 49 45 |...Examp|le: FIE|
|000052f0| 4c 44 5f 4e 41 4d 45 20 | 20 20 4f 50 45 52 41 54 |LD_NAME | OPERAT|
|00005300| 4f 52 20 20 20 20 20 20 | 20 20 44 41 54 41 20 20 |OR | DATA |
|00005310| 20 20 20 20 43 4f 4e 4e | 45 43 54 4f 52 0d 0a 09 | CONN|ECTOR...|
|00005320| 20 20 20 20 20 20 20 20 | 20 20 4c 61 73 74 5f 4e | | Last_N|
|00005330| 61 6d 65 20 20 20 20 62 | 65 67 69 6e 73 20 77 69 |ame b|egins wi|
|00005340| 74 68 20 20 20 20 20 22 | 53 6d 69 74 68 22 20 20 |th "|Smith" |
|00005350| 20 41 4e 44 0d 0a 09 20 | 20 20 20 20 20 20 20 20 | AND... | |
|00005360| 20 53 45 58 20 20 20 20 | 20 20 20 20 20 20 69 73 | SEX | is|
|00005370| 20 74 68 65 20 73 61 6d | 65 20 61 73 20 20 22 46 | the sam|e as "F|
|00005380| 45 4d 41 4c 45 22 0d 0a | 0d 0a 49 6e 20 74 68 65 |EMALE"..|..In the|
|00005390| 20 61 62 6f 76 65 20 65 | 78 61 6d 70 6c 65 20 74 | above e|xample t|
|000053a0| 68 65 20 70 65 72 73 6f | 6e 20 6d 75 73 74 20 68 |he perso|n must h|
|000053b0| 61 76 65 20 61 20 6c 61 | 73 74 20 6e 61 6d 65 20 |ave a la|st name |
|000053c0| 74 68 61 74 20 62 65 67 | 69 6e 73 20 77 69 74 68 |that beg|ins with|
|000053d0| 20 53 6d 69 74 68 22 20 | 20 41 4e 44 20 20 74 68 | Smith" | AND th|
|000053e0| 65 79 20 6d 75 73 74 20 | 62 65 20 61 20 66 65 6d |ey must |be a fem|
|000053f0| 61 6c 65 2e 20 49 66 20 | 74 68 65 20 63 6f 6e 6e |ale. If |the conn|
|00005400| 65 63 74 6f 72 20 77 65 | 72 65 20 61 6e 20 22 4f |ector we|re an "O|
|00005410| 52 22 20 74 68 65 6e 20 | 74 68 65 20 70 65 72 73 |R" then |the pers|
|00005420| 6f 6e 20 6d 75 73 74 20 | 68 61 76 65 20 61 20 6c |on must |have a l|
|00005430| 61 73 74 20 6e 61 6d 65 | 20 74 68 61 74 20 62 65 |ast name| that be|
|00005440| 67 69 6e 73 20 77 69 74 | 68 20 22 53 6d 69 74 68 |gins wit|h "Smith|
|00005450| 22 20 20 4f 52 20 20 74 | 68 65 79 20 6d 75 73 74 |" OR t|hey must|
|00005460| 20 62 65 20 61 20 66 65 | 6d 61 6c 65 2e 20 41 20 | be a fe|male. A |
|00005470| 6c 69 73 74 20 6f 66 20 | 70 65 6f 70 6c 65 20 62 |list of |people b|
|00005480| 61 73 65 64 20 6f 6e 20 | 74 68 65 20 41 4e 44 20 |ased on |the AND |
|00005490| 43 4f 4e 4e 45 43 54 4f | 52 20 77 6f 75 6c 64 20 |CONNECTO|R would |
|000054a0| 62 65 20 66 65 6d 61 6c | 65 73 20 77 68 6f 73 65 |be femal|es whose|
|000054b0| 20 6c 61 73 74 20 6e 61 | 6d 65 73 20 62 65 67 69 | last na|mes begi|
|000054c0| 6e 20 77 69 74 68 20 22 | 53 6d 69 74 68 22 2e 20 |n with "|Smith". |
|000054d0| 41 20 6c 69 73 74 20 6f | 66 20 70 65 6f 70 6c 65 |A list o|f people|
|000054e0| 20 62 61 73 65 64 20 6f | 6e 20 74 68 65 20 4f 52 | based o|n the OR|
|000054f0| 20 43 4f 4e 4e 45 43 54 | 4f 52 20 77 6f 75 6c 64 | CONNECT|OR would|
|00005500| 20 62 65 20 61 6c 6c 20 | 66 65 6d 61 6c 65 73 20 | be all |females |
|00005510| 6f 72 20 61 6e 79 62 6f | 64 79 20 77 68 6f 73 65 |or anybo|dy whose|
|00005520| 20 6c 61 73 74 20 6e 61 | 6d 65 73 20 62 65 67 69 | last na|mes begi|
|00005530| 6e 20 77 69 74 68 20 22 | 53 6d 69 74 68 22 28 6d |n with "|Smith"(m|
|00005540| 61 6c 65 20 6f 72 20 66 | 65 6d 61 6c 65 29 2e 0d |ale or f|emale)..|
|00005550| 0a 0d 0a 0d 0a 50 68 72 | 61 73 65 73 20 6d 61 79 |.....Phr|ases may|
|00005560| 20 62 65 20 70 75 74 20 | 69 6e 20 64 69 66 66 65 | be put |in diffe|
|00005570| 72 65 6e 74 20 67 72 6f | 75 70 73 2e 20 54 68 65 |rent gro|ups. The|
|00005580| 20 70 68 72 61 73 65 73 | 20 69 6e 20 74 68 65 20 | phrases| in the |
|00005590| 31 73 74 20 67 72 6f 75 | 70 20 61 72 65 20 65 76 |1st grou|p are ev|
|000055a0| 61 6c 75 61 74 65 64 20 | 61 73 20 61 20 67 72 6f |aluated |as a gro|
|000055b0| 75 70 20 62 65 66 6f 72 | 65 20 74 68 65 20 70 68 |up befor|e the ph|
|000055c0| 72 61 73 65 73 20 69 6e | 20 74 68 65 20 32 6e 64 |rases in| the 2nd|
|000055d0| 20 67 72 6f 75 70 20 61 | 72 65 20 65 76 61 6c 75 | group a|re evalu|
|000055e0| 61 74 65 64 2c 20 61 6e | 64 20 74 68 65 20 70 68 |ated, an|d the ph|
|000055f0| 72 61 73 65 73 20 69 6e | 20 74 68 65 20 32 6e 64 |rases in| the 2nd|
|00005600| 20 67 72 6f 75 70 20 61 | 72 65 20 65 76 61 6c 75 | group a|re evalu|
|00005610| 61 74 65 64 20 61 73 20 | 61 20 67 72 6f 75 70 20 |ated as |a group |
|00005620| 62 65 66 6f 72 65 20 74 | 68 65 20 70 68 72 61 73 |before t|he phras|
|00005630| 65 73 20 69 6e 20 74 68 | 65 20 33 72 64 20 67 72 |es in th|e 3rd gr|
|00005640| 6f 75 70 20 61 72 65 20 | 65 76 61 6c 75 61 74 65 |oup are |evaluate|
|00005650| 64 2c 20 65 74 63 2e 2e | 2e 0d 0a 0d 0a 50 75 74 |d, etc..|.....Put|
|00005660| 74 69 6e 67 20 70 68 72 | 61 73 65 73 20 69 6e 20 |ting phr|ases in |
|00005670| 61 20 64 69 66 66 65 72 | 65 6e 74 20 67 72 6f 75 |a differ|ent grou|
|00005680| 70 20 77 69 6c 6c 20 6e | 6f 72 6d 61 6c 6c 79 20 |p will n|ormally |
|00005690| 6e 6f 74 20 62 65 20 6e | 65 63 65 73 73 61 72 79 |not be n|ecessary|
|000056a0| 20 75 6e 6c 65 73 73 20 | 74 68 65 20 73 65 6c 65 | unless |the sele|
|000056b0| 63 74 69 6f 6e 20 63 72 | 69 74 65 72 69 61 20 61 |ction cr|iteria a|
|000056c0| 72 65 20 76 65 72 79 20 | 63 6f 6d 70 6c 69 63 61 |re very |complica|
|000056d0| 74 65 64 2e 0d 0a 0d 0a | 0d 0a 45 78 61 6d 70 6c |ted.....|..Exampl|
|000056e0| 65 3a 20 0d 0a 0d 0a 20 | 46 49 45 4c 44 5f 4e 41 |e: .... |FIELD_NA|
|000056f0| 4d 45 20 20 4f 50 45 52 | 41 54 4f 52 20 20 20 20 |ME OPER|ATOR |
|00005700| 20 20 20 20 44 41 54 41 | 20 20 20 20 20 20 43 4f | DATA| CO|
|00005710| 4e 4e 45 43 54 4f 52 20 | 20 47 52 4f 55 50 0d 0a |NNECTOR | GROUP..|
|00005720| 20 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 20 20 2d 2d 2d | -------|--- ---|
|00005730| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 20 20 2d 2d 2d |--------|--- ---|
|00005740| 2d 2d 2d 2d 2d 20 20 2d | 2d 2d 2d 2d 2d 2d 2d 2d |----- -|--------|
|00005750| 20 20 2d 2d 2d 2d 2d 20 | 20 0d 0a 20 4c 41 53 54 | ----- | .. LAST|
|00005760| 5f 4e 41 4d 45 20 20 20 | 62 65 67 69 6e 73 20 77 |_NAME |begins w|
|00005770| 69 74 68 20 20 20 20 20 | 22 53 6d 69 74 68 22 20 |ith |"Smith" |
|00005780| 20 20 4f 52 20 20 20 20 | 20 20 20 20 20 31 0d 0a | OR | 1..|
|00005790| 20 53 45 58 20 20 20 20 | 20 20 20 20 20 69 73 20 | SEX | is |
|000057a0| 74 68 65 20 73 61 6d 65 | 20 61 73 20 20 22 46 45 |the same| as "FE|
|000057b0| 4d 41 4c 45 22 20 20 41 | 4e 44 20 20 20 20 20 20 |MALE" A|ND |
|000057c0| 20 20 31 0d 0a 20 50 48 | 4f 4e 45 20 20 20 20 20 | 1.. PH|ONE |
|000057d0| 20 20 43 4f 4e 54 41 49 | 4e 53 20 20 20 20 20 20 | CONTAI|NS |
|000057e0| 20 20 22 31 32 33 22 20 | 20 20 20 20 20 20 20 20 | "123" | |
|000057f0| 20 20 20 20 20 20 20 32 | 0d 0a 09 20 20 20 20 20 | 2|... |
|00005800| 20 20 20 20 20 20 0d 0a | 0d 0a 49 6e 20 74 68 65 | ..|..In the|
|00005810| 20 61 62 6f 76 65 20 65 | 78 61 6d 70 6c 65 20 74 | above e|xample t|
|00005820| 68 65 20 70 65 72 73 6f | 6e 20 6d 75 73 74 20 68 |he perso|n must h|
|00005830| 61 76 65 20 61 20 6c 61 | 73 74 20 6e 61 6d 65 20 |ave a la|st name |
|00005840| 74 68 61 74 20 62 65 67 | 69 6e 73 20 77 69 74 68 |that beg|ins with|
|00005850| 20 22 53 6d 69 74 68 22 | 20 20 4f 52 20 20 74 68 | "Smith"| OR th|
|00005860| 65 79 20 6d 75 73 74 20 | 62 65 20 61 20 66 65 6d |ey must |be a fem|
|00005870| 61 6c 65 2e 20 41 6e 79 | 6f 6e 65 20 6d 61 74 63 |ale. Any|one matc|
|00005880| 68 69 6e 67 20 74 68 65 | 20 61 62 6f 76 65 20 63 |hing the| above c|
|00005890| 72 69 74 65 72 69 61 20 | 6d 75 73 74 20 61 6c 73 |riteria |must als|
|000058a0| 6f 20 68 61 76 65 20 61 | 20 70 68 6f 6e 65 20 6e |o have a| phone n|
|000058b0| 75 6d 62 65 72 20 74 68 | 61 74 20 63 6f 6e 74 61 |umber th|at conta|
|000058c0| 69 6e 73 20 22 31 32 33 | 22 2e 20 49 74 20 77 6f |ins "123|". It wo|
|000058d0| 75 6c 64 20 6c 69 73 74 | 20 72 65 63 6f 72 64 73 |uld list| records|
|000058e0| 20 6c 69 6b 65 3a 0d 0a | 0d 0a 20 20 4e 61 6d 65 | like:..|.. Name|
|000058f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005900| 20 20 20 20 20 53 65 78 | 20 20 20 20 20 20 20 20 | Sex| |
|00005910| 20 20 20 20 20 20 20 20 | 20 20 50 68 6f 6e 65 0d | | Phone.|
|00005920| 0a 20 1a 42 69 6c 6c 20 | 53 6d 69 74 68 20 20 20 |. .Bill |Smith |
|00005930| 20 20 20 20 20 20 20 20 | 20 20 20 20 4d 61 6c 65 | | Male|
|00005940| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005950| 1a 34 34 34 2d 31 32 33 | 34 0d 0a 20 20 4a 61 6e |.444-123|4.. Jan|
|00005960| 65 20 44 6f 65 20 20 20 | 20 20 20 20 20 20 20 20 |e Doe | |
|00005970| 20 20 20 20 20 1a 46 65 | 6d 61 6c 65 20 20 20 20 | .Fe|male |
|00005980| 20 20 20 20 20 20 20 20 | 20 20 1a 31 32 33 2d 34 | | .123-4|
|00005990| 34 34 34 20 0d 0a 09 20 | 0d 0a 28 22 1a 22 20 6d |444 ... |..("." m|
|000059a0| 61 72 6b 73 20 6d 61 74 | 63 68 69 6e 67 20 63 72 |arks mat|ching cr|
|000059b0| 69 74 65 72 69 61 29 09 | 20 0d 0a 0d 0a 49 74 20 |iteria).| ....It |
|000059c0| 77 6f 75 6c 64 20 6e 6f | 74 20 6c 69 73 74 20 72 |would no|t list r|
|000059d0| 65 63 6f 72 64 73 20 6c | 69 6b 65 3a 0d 0a 0d 0a |ecords l|ike:....|
|000059e0| 20 20 4e 61 6d 65 20 20 | 20 20 20 20 20 20 20 20 | Name | |
|000059f0| 20 20 20 20 20 20 20 20 | 20 20 20 53 65 78 20 20 | | Sex |
|00005a00| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005a10| 50 68 6f 6e 65 0d 0a 20 | 1a 42 69 6c 6c 20 4e 61 |Phone.. |.Bill Na|
|00005a20| 69 73 6d 69 74 68 20 20 | 20 20 20 20 20 20 20 20 |ismith | |
|00005a30| 20 1a 4d 61 6c 65 20 20 | 20 20 20 20 20 20 20 20 | .Male | |
|00005a40| 20 20 20 20 20 20 20 34 | 34 34 2d 31 32 33 34 0d | 4|44-1234.|
|00005a50| 0a 20 1a 4a 61 6e 65 20 | 44 6f 65 20 20 20 20 20 |. .Jane |Doe |
|00005a60| 20 20 20 20 20 20 20 20 | 20 20 20 20 66 65 6d 61 | | fema|
|00005a70| 6c 65 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |le | |
|00005a80| 1a 33 33 33 2d 34 34 34 | 34 20 0d 0a 09 20 0d 0a |.333-444|4 ... ..|
|00005a90| 28 22 1a 22 20 6d 61 72 | 6b 73 20 6e 6f 6e 65 20 |("." mar|ks none |
|00005aa0| 6d 61 74 63 68 69 6e 67 | 20 63 72 69 74 65 72 69 |matching| criteri|
|00005ab0| 61 29 09 20 0d 0a 0d 0a | 0d 0a 0d 0a 54 68 65 20 |a). ....|....The |
|00005ac0| 46 6f 78 50 72 6f 20 65 | 78 70 72 65 73 73 69 6f |FoxPro e|xpressio|
|00005ad0| 6e 20 62 75 69 6c 64 65 | 72 20 69 73 20 61 6c 73 |n builde|r is als|
|00005ae0| 6f 20 61 76 61 69 6c 61 | 62 6c 65 20 69 6e 20 74 |o availa|ble in t|
|00005af0| 68 69 73 20 65 78 70 72 | 65 73 73 69 6f 6e 20 62 |his expr|ession b|
|00005b00| 75 69 6c 64 65 72 2c 20 | 62 75 74 20 69 74 20 69 |uilder, |but it i|
|00005b10| 73 20 6e 6f 74 20 72 65 | 63 6f 6d 6d 65 6e 64 65 |s not re|commende|
|00005b20| 64 20 75 6e 6c 65 73 73 | 20 79 6f 75 20 61 72 65 |d unless| you are|
|00005b30| 20 66 61 6d 69 6c 69 61 | 72 20 77 69 74 68 20 74 | familia|r with t|
|00005b40| 68 65 20 46 6f 78 50 72 | 6f 20 73 6f 66 74 77 61 |he FoxPr|o softwa|
|00005b50| 72 65 2e 0d 0a 0d 0a 0d | 0a 59 6f 75 20 6d 61 79 |re......|.You may|
|00005b60| 20 62 75 69 6c 64 20 61 | 6e 20 65 78 70 72 65 73 | build a|n expres|
|00005b70| 73 69 6f 6e 20 66 72 6f | 6d 20 73 63 72 61 74 63 |sion fro|m scratc|
|00005b80| 68 20 69 6e 20 74 68 65 | 20 46 6f 78 50 72 6f 20 |h in the| FoxPro |
|00005b90| 65 78 70 72 65 73 73 69 | 6f 6e 20 62 75 69 6c 64 |expressi|on build|
|00005ba0| 65 72 2c 20 6f 72 20 79 | 6f 75 20 6d 61 79 20 63 |er, or y|ou may c|
|00005bb0| 6f 70 79 20 61 6e 20 65 | 78 69 73 74 69 6e 67 20 |opy an e|xisting |
|00005bc0| 65 78 70 72 65 73 73 69 | 6f 6e 20 61 73 20 61 20 |expressi|on as a |
|00005bd0| 73 74 61 72 74 69 6e 67 | 20 70 6f 69 6e 74 2e 6f |starting| point.o|
|00005be0| 69 6e 74 2e 69 6e 74 2e | 43 48 45 4d 45 20 32 31 |int.int.|CHEME 21|
|00005bf0| 0d 0a 20 20 20 20 20 20 | 20 45 4e 44 49 46 20 2e |.. | ENDIF .|
|00005c00| 00 00 00 01 00 00 00 bf | 54 68 65 20 45 78 70 72 |........|The Expr|
|00005c10| 65 73 73 69 6f 6e 20 4d | 65 6e 75 20 69 73 20 74 |ession M|enu is t|
|00005c20| 68 65 20 63 6f 6e 74 72 | 6f 6c 20 63 65 6e 74 65 |he contr|ol cente|
|00005c30| 72 20 66 6f 72 20 74 68 | 65 20 63 75 73 74 6f 6d |r for th|e custom|
|00005c40| 20 65 78 70 72 65 73 73 | 69 6f 6e 20 62 75 69 6c | express|ion buil|
|00005c50| 64 65 72 2e 0d 0a 0d 0a | 4f 6e 20 74 68 65 20 6c |der.....|On the l|
|00005c60| 65 66 74 20 6f 66 20 74 | 68 65 20 73 63 72 65 65 |eft of t|he scree|
|00005c70| 6e 20 69 73 20 74 68 65 | 20 6c 69 73 74 20 6f 66 |n is the| list of|
|00005c80| 20 65 78 70 72 65 73 73 | 69 6f 6e 73 2e 0d 0a 0d | express|ions....|
|00005c90| 0a 4f 6e 20 74 68 65 20 | 72 69 67 68 74 20 6f 66 |.On the |right of|
|00005ca0| 20 74 68 65 20 73 63 72 | 65 65 6e 20 69 73 20 74 | the scr|een is t|
|00005cb0| 68 65 20 45 78 70 72 65 | 73 73 69 6f 6e 20 4d 65 |he Expre|ssion Me|
|00005cc0| 6e 75 2e 0d 0a 0d 0a 73 | 76 73 65 73 20 73 61 73 |nu.....s|vses sas|
|00005cd0| 73 73 2e 73 2e 73 2e 73 | 20 73 20 73 20 73 20 73 |ss.s.s.s| s s s s|
|00005ce0| 20 73 20 73 20 73 b3 70 | b3 70 20 70 52 7f 65 70 | s s s.p|.p pR.ep|
|00005cf0| 76 70 65 70 72 70 74 70 | 20 70 20 70 20 70 20 70 |vpeprptp| p p p p|
|00005d00| 00 00 00 01 00 00 01 10 | 54 68 65 20 45 78 70 72 |........|The Expr|
|00005d10| 65 73 73 69 6f 6e 20 4d | 65 6e 75 20 69 73 20 74 |ession M|enu is t|
|00005d20| 68 65 20 63 6f 6e 74 72 | 6f 6c 20 63 65 6e 74 65 |he contr|ol cente|
|00005d30| 72 20 66 6f 72 20 74 68 | 65 20 63 75 73 74 6f 6d |r for th|e custom|
|00005d40| 20 65 78 70 72 65 73 73 | 69 6f 6e 20 62 75 69 6c | express|ion buil|
|00005d50| 64 65 72 2e 0d 0a 0d 0a | 4f 6e 20 74 68 65 20 6c |der.....|On the l|
|00005d60| 65 66 74 20 6f 66 20 74 | 68 65 20 73 63 72 65 65 |eft of t|he scree|
|00005d70| 6e 20 69 73 20 74 68 65 | 20 6c 69 73 74 20 6f 66 |n is the| list of|
|00005d80| 20 65 78 70 72 65 73 73 | 69 6f 6e 73 2e 0d 0a 0d | express|ions....|
|00005d90| 0a 4f 6e 20 74 68 65 20 | 72 69 67 68 74 20 6f 66 |.On the |right of|
|00005da0| 20 74 68 65 20 73 63 72 | 65 65 6e 20 69 73 20 74 | the scr|een is t|
|00005db0| 68 65 20 45 78 70 72 65 | 73 73 69 6f 6e 20 4d 65 |he Expre|ssion Me|
|00005dc0| 6e 75 2e 0d 0a 0d 0a 54 | 68 65 20 45 78 70 72 65 |nu.....T|he Expre|
|00005dd0| 73 73 69 6f 6e 20 4d 65 | 6e 75 20 68 61 73 20 74 |ssion Me|nu has t|
|00005de0| 68 65 20 66 6f 6c 6c 6f | 77 69 6e 67 20 6f 70 74 |he follo|wing opt|
|00005df0| 69 6f 6e 73 3a 0d 0a 0d | 0a 09 31 2e 09 41 64 64 |ions:...|..1..Add|
|00005e00| 2f 43 72 65 61 74 65 20 | 61 20 6e 65 77 20 65 78 |/Create |a new ex|
|00005e10| 70 72 65 73 73 69 6f 6e | cd 00 89 f2 89 fb e8 3e |pression|.......>|
|00005e20| da 85 c0 74 22 c6 46 f6 | bf c6 46 f7 00 31 c0 50 |...t".F.|..F..1.P|
|00005e30| 8d 46 f6 50 89 f0 89 ca | bb 01 00 31 c9 e8 e9 d8 |.F.P....|...1....|
|00005e40| 00 00 00 01 00 00 02 50 | 54 68 65 20 45 78 70 72 |.......P|The Expr|
|00005e50| 65 73 73 69 6f 6e 20 4d | 65 6e 75 20 69 73 20 74 |ession M|enu is t|
|00005e60| 68 65 20 63 6f 6e 74 72 | 6f 6c 20 63 65 6e 74 65 |he contr|ol cente|
|00005e70| 72 20 66 6f 72 20 74 68 | 65 20 63 75 73 74 6f 6d |r for th|e custom|
|00005e80| 20 65 78 70 72 65 73 73 | 69 6f 6e 20 62 75 69 6c | express|ion buil|
|00005e90| 64 65 72 2e 0d 0a 0d 0a | 4f 6e 20 74 68 65 20 6c |der.....|On the l|
|00005ea0| 65 66 74 20 6f 66 20 74 | 68 65 20 73 63 72 65 65 |eft of t|he scree|
|00005eb0| 6e 20 69 73 20 74 68 65 | 20 6c 69 73 74 20 6f 66 |n is the| list of|
|00005ec0| 20 65 78 70 72 65 73 73 | 69 6f 6e 73 2e 0d 0a 0d | express|ions....|
|00005ed0| 0a 4f 6e 20 74 68 65 20 | 72 69 67 68 74 20 6f 66 |.On the |right of|
|00005ee0| 20 74 68 65 20 73 63 72 | 65 65 6e 20 69 73 20 74 | the scr|een is t|
|00005ef0| 68 65 20 45 78 70 72 65 | 73 73 69 6f 6e 20 4d 65 |he Expre|ssion Me|
|00005f00| 6e 75 2e 0d 0a 0d 0a 54 | 68 65 20 45 78 70 72 65 |nu.....T|he Expre|
|00005f10| 73 73 69 6f 6e 20 4d 65 | 6e 75 20 68 61 73 20 74 |ssion Me|nu has t|
|00005f20| 68 65 20 66 6f 6c 6c 6f | 77 69 6e 67 20 6f 70 74 |he follo|wing opt|
|00005f30| 69 6f 6e 73 3a 0d 0a 0d | 0a 09 31 2e 09 41 64 64 |ions:...|..1..Add|
|00005f40| 2f 43 72 65 61 74 65 20 | 61 20 6e 65 77 20 65 78 |/Create |a new ex|
|00005f50| 70 72 65 73 73 69 6f 6e | 0d 0a 09 0d 0a 09 32 2e |pression|......2.|
|00005f60| 09 45 64 69 74 20 74 68 | 65 20 6e 61 6d 65 2f 64 |.Edit th|e name/d|
|00005f70| 65 73 63 72 69 70 74 69 | 6f 6e 20 6f 66 20 74 68 |escripti|on of th|
|00005f80| 65 20 65 78 70 72 65 73 | 73 69 6f 6e 0d 0a 09 0d |e expres|sion....|
|00005f90| 0a 09 33 2e 09 45 64 69 | 74 20 74 68 65 20 65 78 |..3..Edi|t the ex|
|00005fa0| 70 72 65 73 73 69 6f 6e | 20 69 74 73 65 6c 66 0d |pression| itself.|
|00005fb0| 0a 09 0d 0a 09 34 2e 09 | 53 65 6c 65 63 74 20 61 |.....4..|Select a|
|00005fc0| 6e 20 65 78 70 72 65 73 | 73 69 6f 6e 0d 0a 09 0d |n expres|sion....|
|00005fd0| 0a 09 35 2e 09 56 69 65 | 77 20 74 68 65 20 65 78 |..5..Vie|w the ex|
|00005fe0| 70 72 65 73 73 69 6f 6e | 20 63 72 69 74 65 72 69 |pression| criteri|
|00005ff0| 61 0d 0a 09 0d 0a 09 36 | 2e 09 43 68 61 6e 67 65 |a......6|..Change|
|00006000| 20 74 68 65 20 49 67 6e | 6f 72 65 5f 43 61 73 65 | the Ign|ore_Case|
|00006010| 20 73 65 74 74 69 6e 67 | 0d 0a 09 0d 0a 09 37 2e | setting|......7.|
|00006020| 09 44 65 6c 65 74 65 2f | 45 72 61 73 65 20 74 68 |.Delete/|Erase th|
|00006030| 65 20 65 78 70 72 65 73 | 73 69 6f 6e 0d 0a 09 0d |e expres|sion....|
|00006040| 0a 09 38 2e 09 44 6f 6e | 65 2d 20 4c 65 61 76 65 |..8..Don|e- Leave|
|00006050| 20 65 78 70 72 65 73 73 | 69 6f 6e 20 62 75 69 6c | express|ion buil|
|00006060| 64 65 72 20 61 6e 64 20 | 73 65 74 20 73 65 6c 65 |der and |set sele|
|00006070| 63 74 65 64 20 63 72 69 | 74 65 72 69 61 20 69 6e |cted cri|teria in|
|00006080| 74 6f 20 65 66 66 65 63 | 74 0d 0a 09 0d 0a 09 39 |to effec|t......9|
|00006090| 2e 09 0d 0a 09 0d 0a 09 | 20 20 20 63 61 73 65 20 |........| case |
|000060a0| 69 6e 6c 69 73 74 28 6f | 70 65 72 61 74 6f 72 2c |inlist(o|perator,|
|000060b0| 27 46 20 27 2c 27 54 20 | 27 29 0d 0a 20 20 20 20 |'F ','T |').. |
|000060c0| 00 00 00 01 00 00 02 9f | 54 68 65 20 45 78 70 72 |........|The Expr|
|000060d0| 65 73 73 69 6f 6e 20 4d | 65 6e 75 20 69 73 20 74 |ession M|enu is t|
|000060e0| 68 65 20 63 6f 6e 74 72 | 6f 6c 20 63 65 6e 74 65 |he contr|ol cente|
|000060f0| 72 20 66 6f 72 20 74 68 | 65 20 63 75 73 74 6f 6d |r for th|e custom|
|00006100| 20 65 78 70 72 65 73 73 | 69 6f 6e 20 62 75 69 6c | express|ion buil|
|00006110| 64 65 72 2e 0d 0a 0d 0a | 4f 6e 20 74 68 65 20 6c |der.....|On the l|
|00006120| 65 66 74 20 6f 66 20 74 | 68 65 20 73 63 72 65 65 |eft of t|he scree|
|00006130| 6e 20 69 73 20 74 68 65 | 20 6c 69 73 74 20 6f 66 |n is the| list of|
|00006140| 20 65 78 70 72 65 73 73 | 69 6f 6e 73 2e 0d 0a 0d | express|ions....|
|00006150| 0a 4f 6e 20 74 68 65 20 | 72 69 67 68 74 20 6f 66 |.On the |right of|
|00006160| 20 74 68 65 20 73 63 72 | 65 65 6e 20 69 73 20 74 | the scr|een is t|
|00006170| 68 65 20 45 78 70 72 65 | 73 73 69 6f 6e 20 4d 65 |he Expre|ssion Me|
|00006180| 6e 75 2e 0d 0a 0d 0a 54 | 68 65 20 45 78 70 72 65 |nu.....T|he Expre|
|00006190| 73 73 69 6f 6e 20 4d 65 | 6e 75 20 68 61 73 20 74 |ssion Me|nu has t|
|000061a0| 68 65 20 66 6f 6c 6c 6f | 77 69 6e 67 20 6f 70 74 |he follo|wing opt|
|000061b0| 69 6f 6e 73 3a 0d 0a 0d | 0a 09 31 2e 09 41 64 64 |ions:...|..1..Add|
|000061c0| 2f 43 72 65 61 74 65 20 | 61 20 6e 65 77 20 65 78 |/Create |a new ex|
|000061d0| 70 72 65 73 73 69 6f 6e | 0d 0a 09 0d 0a 09 32 2e |pression|......2.|
|000061e0| 09 45 64 69 74 20 74 68 | 65 20 6e 61 6d 65 2f 64 |.Edit th|e name/d|
|000061f0| 65 73 63 72 69 70 74 69 | 6f 6e 20 6f 66 20 74 68 |escripti|on of th|
|00006200| 65 20 65 78 70 72 65 73 | 73 69 6f 6e 0d 0a 09 0d |e expres|sion....|
|00006210| 0a 09 33 2e 09 45 64 69 | 74 20 74 68 65 20 65 78 |..3..Edi|t the ex|
|00006220| 70 72 65 73 73 69 6f 6e | 20 69 74 73 65 6c 66 0d |pression| itself.|
|00006230| 0a 09 0d 0a 09 34 2e 09 | 53 65 6c 65 63 74 20 61 |.....4..|Select a|
|00006240| 6e 20 65 78 70 72 65 73 | 73 69 6f 6e 20 66 6f 72 |n expres|sion for|
|00006250| 20 75 73 65 0d 0a 09 0d | 0a 09 35 2e 09 56 69 65 | use....|..5..Vie|
|00006260| 77 20 74 68 65 20 65 78 | 70 72 65 73 73 69 6f 6e |w the ex|pression|
|00006270| 20 63 72 69 74 65 72 69 | 61 0d 0a 09 0d 0a 09 36 | criteri|a......6|
|00006280| 2e 09 43 68 61 6e 67 65 | 20 74 68 65 20 49 67 6e |..Change| the Ign|
|00006290| 6f 72 65 5f 43 61 73 65 | 20 73 65 74 74 69 6e 67 |ore_Case| setting|
|000062a0| 0d 0a 09 0d 0a 09 37 2e | 09 44 65 6c 65 74 65 2f |......7.|.Delete/|
|000062b0| 45 72 61 73 65 20 74 68 | 65 20 65 78 70 72 65 73 |Erase th|e expres|
|000062c0| 73 69 6f 6e 0d 0a 09 0d | 0a 09 38 2e 09 44 6f 6e |sion....|..8..Don|
|000062d0| 65 2d 20 4c 65 61 76 65 | 20 65 78 70 72 65 73 73 |e- Leave| express|
|000062e0| 69 6f 6e 20 62 75 69 6c | 64 65 72 20 61 6e 64 20 |ion buil|der and |
|000062f0| 73 65 74 20 73 65 6c 65 | 63 74 65 64 20 63 72 69 |set sele|cted cri|
|00006300| 74 65 72 69 61 20 69 6e | 74 6f 20 65 66 66 65 63 |teria in|to effec|
|00006310| 74 0d 0a 09 0d 0a 09 39 | 2e 09 41 62 6f 72 74 2d |t......9|..Abort-|
|00006320| 4c 65 61 76 65 20 65 78 | 70 72 65 73 73 69 6f 6e |Leave ex|pression|
|00006330| 20 62 75 69 6c 64 65 72 | 20 77 69 74 68 20 6e 6f | builder| with no|
|00006340| 20 65 78 70 72 65 73 73 | 69 6f 6e 20 63 72 69 74 | express|ion crit|
|00006350| 65 72 69 61 20 69 6e 20 | 65 66 66 65 63 74 0d 0a |eria in |effect..|
|00006360| 09 0d 0a 09 0d 0a 09 20 | 20 20 20 20 20 69 69 66 |....... | iif|
|00006370| 28 71 6d 5f 63 68 6f 69 | 63 65 3c 3e 34 2c 27 28 |(qm_choi|ce<>4,'(|
|00006380| 00 00 00 01 00 00 03 30 | 54 68 65 20 45 78 70 72 |.......0|The Expr|
|00006390| 65 73 73 69 6f 6e 20 4d | 65 6e 75 20 69 73 20 74 |ession M|enu is t|
|000063a0| 68 65 20 63 6f 6e 74 72 | 6f 6c 20 63 65 6e 74 65 |he contr|ol cente|
|000063b0| 72 20 66 6f 72 20 74 68 | 65 20 63 75 73 74 6f 6d |r for th|e custom|
|000063c0| 20 65 78 70 72 65 73 73 | 69 6f 6e 20 62 75 69 6c | express|ion buil|
|000063d0| 64 65 72 2e 0d 0a 0d 0a | 4f 6e 20 74 68 65 20 6c |der.....|On the l|
|000063e0| 65 66 74 20 6f 66 20 74 | 68 65 20 73 63 72 65 65 |eft of t|he scree|
|000063f0| 6e 20 69 73 20 74 68 65 | 20 6c 69 73 74 20 6f 66 |n is the| list of|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.